PREVIEW / etf_30min / 2010-10-18

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-10-18.parquet
  size:    265 KB
  rows:    8,907

schema

  timestamp    TIMESTAMP
  symbol       VARCHAR
  asset_type   VARCHAR
  open         DOUBLE
  high         DOUBLE
  low          DOUBLE
  close        DOUBLE
  volume       DOUBLE

sample rows

timestamp	symbol	asset_type	open	high	low	close	volume
2010-10-18 04:00:00	SPY	ETF	117.55	117.55	116.97	117.14	32360.0
2010-10-18 04:30:00	SPY	ETF	117.16	117.32	117.13	117.32	600.0
2010-10-18 05:00:00	SPY	ETF	117.29	117.44	117.29	117.41	3000.0
2010-10-18 05:30:00	SPY	ETF	117.44	117.55	117.44	117.53	8300.0
2010-10-18 06:00:00	SPY	ETF	117.5	117.64	117.42	117.63	8900.0
2010-10-18 06:30:00	SPY	ETF	117.63	117.64	117.53	117.56	24575.0
2010-10-18 07:00:00	SPY	ETF	117.57	117.57	117.43	117.47	191593.0
2010-10-18 07:30:00	SPY	ETF	117.46	117.59	117.41	117.43	219757.0
2010-10-18 08:00:00	SPY	ETF	117.47	117.78	117.26	117.72	595712.0
2010-10-18 08:30:00	SPY	ETF	117.72	117.82	117.65	117.81	438081.0
2010-10-18 09:00:00	SPY	ETF	117.81	117.83	117.51	117.73	1238113.0
2010-10-18 09:30:00	SPY	ETF	117.74	118.1	117.52	117.99	18351197.0
2010-10-18 10:00:00	SPY	ETF	117.99	118.28	117.86	118.0	21510702.0
2010-10-18 10:30:00	SPY	ETF	118.0	118.25	117.95	118.21	7498740.0
2010-10-18 11:00:00	SPY	ETF	118.22	118.25	117.31	117.99	9986699.0
2010-10-18 11:30:00	SPY	ETF	117.9968	118.04	117.81	118.01	5244502.0
2010-10-18 12:00:00	SPY	ETF	118.02	118.1	117.96	117.9999	5676134.0
2010-10-18 12:30:00	SPY	ETF	117.9999	118.08	117.92	117.98	4520062.0
2010-10-18 13:00:00	SPY	ETF	117.97	118.13	117.97	118.04	4577430.0
2010-10-18 13:30:00	SPY	ETF	118.03	118.12	117.99	118.06	3926571.0
2010-10-18 14:00:00	SPY	ETF	118.0575	118.32	117.99	118.3	7525761.0
2010-10-18 14:30:00	SPY	ETF	118.3	118.35	118.23	118.32	5145837.0
2010-10-18 15:00:00	SPY	ETF	118.3141	118.67	118.31	118.51	12227631.0
2010-10-18 15:30:00	SPY	ETF	118.5199	118.65	118.46	118.55	15814446.0
2010-10-18 16:00:00	SPY	ETF	118.54	118.66	117.615	118.4	6917846.0
2010-10-18 16:30:00	SPY	ETF	118.4	118.43	117.6	117.65	4582308.0
2010-10-18 17:00:00	SPY	ETF	117.65	117.91	117.63	117.74	1047050.0
2010-10-18 17:30:00	SPY	ETF	117.75	117.86	117.7072	117.8	2320635.0
2010-10-18 18:00:00	SPY	ETF	117.77	117.8	117.62	117.65	205308.0
2010-10-18 18:30:00	SPY	ETF	117.64	117.73	117.61	117.72	166681.0
2010-10-18 19:00:00	SPY	ETF	117.73	117.85	117.73	117.79	33613.0
2010-10-18 19:30:00	SPY	ETF	117.82	117.87	117.81	117.84	36633.0
2010-10-18 04:00:00	QQQ	ETF	51.37	51.37	51.21	51.27	1000.0
2010-10-18 05:00:00	QQQ	ETF	51.37	51.37	51.37	51.37	100.0
2010-10-18 07:00:00	QQQ	ETF	51.38	51.4	51.37	51.39	70895.0
2010-10-18 07:30:00	QQQ	ETF	51.4	51.43	51.35	51.36	199956.0
2010-10-18 08:00:00	QQQ	ETF	51.38	51.55	51.32	51.53	293972.0
2010-10-18 08:30:00	QQQ	ETF	51.53	51.57	51.48	51.53	267480.0
2010-10-18 09:00:00	QQQ	ETF	51.53	51.55	51.38	51.51	427368.0
2010-10-18 09:30:00	QQQ	ETF	51.52	51.61	51.33	51.5599	8012251.0
2010-10-18 10:00:00	QQQ	ETF	51.55	51.63	51.45	51.5	6625486.0
2010-10-18 10:30:00	QQQ	ETF	51.5	51.57	51.45	51.55	4075353.0
2010-10-18 11:00:00	QQQ	ETF	51.55	51.56	51.39	51.46	4591746.0
2010-10-18 11:30:00	QQQ	ETF	51.452	51.47	51.35	51.43	2770499.0
2010-10-18 12:00:00	QQQ	ETF	51.44	51.47	51.39	51.43	2073921.0
2010-10-18 12:30:00	QQQ	ETF	51.43	51.46	51.35	51.36	1735411.0
2010-10-18 13:00:00	QQQ	ETF	51.37	51.45	51.36	51.39	2301299.0
2010-10-18 13:30:00	QQQ	ETF	51.4	51.43	51.365	51.39	2629946.0
2010-10-18 14:00:00	QQQ	ETF	51.39	51.535	51.38	51.52	3684105.0
2010-10-18 14:30:00	QQQ	ETF	51.52	51.54	51.47	51.5	2200211.0

> showing 50 of 8,907 rows — these rows as CSV

> unlock the full archive -- $79 one-time