PREVIEW / etf_30min / 2009-04-30

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-30.parquet
  size:    222 KB
  rows:    7,492

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
2009-04-30 04:00:00	SPY	ETF	88.65	88.7	88.65	88.66	11600.0
2009-04-30 04:30:00	SPY	ETF	88.59	88.8	88.52	88.75	23100.0
2009-04-30 05:00:00	SPY	ETF	88.65	88.87	88.65	88.8	21260.0
2009-04-30 05:30:00	SPY	ETF	88.71	88.87	88.71	88.85	11993.0
2009-04-30 06:00:00	SPY	ETF	88.83	89.1	88.83	89.06	76046.0
2009-04-30 06:30:00	SPY	ETF	89.05	89.14	88.77	88.85	114760.0
2009-04-30 07:00:00	SPY	ETF	88.89	88.92	88.66	88.66	571936.0
2009-04-30 07:30:00	SPY	ETF	88.67	88.79	88.66	88.75	588506.0
2009-04-30 08:00:00	SPY	ETF	88.76	88.86	88.62	88.66	1373006.0
2009-04-30 08:30:00	SPY	ETF	88.65	88.74	88.51	88.63	2554685.0
2009-04-30 09:00:00	SPY	ETF	88.63	88.68	88.37	88.56	2409626.0
2009-04-30 09:30:00	SPY	ETF	88.55	88.79	88.16	88.48	34544944.0
2009-04-30 10:00:00	SPY	ETF	88.47	88.91	88.45	88.79	20684479.0
2009-04-30 10:30:00	SPY	ETF	88.7999	88.89	88.51	88.835	13958559.0
2009-04-30 11:00:00	SPY	ETF	88.83	89.02	88.74	88.8	12368789.0
2009-04-30 11:30:00	SPY	ETF	88.8	88.9	88.298	88.33	17364054.0
2009-04-30 12:00:00	SPY	ETF	88.33	88.42	88.13	88.33	15463210.0
2009-04-30 12:30:00	SPY	ETF	88.34	88.36	87.47	87.66	21886078.0
2009-04-30 13:00:00	SPY	ETF	87.66	87.79	87.15	87.3	20054348.0
2009-04-30 13:30:00	SPY	ETF	87.31	88.62	87.22	87.65	15125142.0
2009-04-30 14:00:00	SPY	ETF	87.65	88.15	87.48	87.91	15509314.0
2009-04-30 14:30:00	SPY	ETF	87.9	87.95	87.52	87.83	15950060.0
2009-04-30 15:00:00	SPY	ETF	87.83	87.87	86.92	87.3	30681558.0
2009-04-30 15:30:00	SPY	ETF	87.3	88.25	87.21	87.44	39992774.0
2009-04-30 16:00:00	SPY	ETF	87.43	87.8	86.97	87.12	15318374.0
2009-04-30 16:30:00	SPY	ETF	87.11	87.25	87.08	87.13	2840714.0
2009-04-30 17:00:00	SPY	ETF	87.14	87.14	86.87	86.89	485300.0
2009-04-30 17:30:00	SPY	ETF	86.92	86.99	86.86	86.99	120664.0
2009-04-30 18:00:00	SPY	ETF	86.95	87.19	86.9	87.18	145980.0
2009-04-30 18:30:00	SPY	ETF	87.16	87.23	87.06	87.21	45880.0
2009-04-30 19:00:00	SPY	ETF	87.21	87.26	87.2	87.2	12821.0
2009-04-30 19:30:00	SPY	ETF	87.21	87.25	87.18	87.24	48135.0
2009-04-30 04:00:00	QQQ	ETF	34.49	34.5	34.49	34.5	3200.0
2009-04-30 04:30:00	QQQ	ETF	34.44	34.5	34.44	34.5	1890.0
2009-04-30 05:00:00	QQQ	ETF	34.52	34.54	34.52	34.54	300.0
2009-04-30 05:30:00	QQQ	ETF	34.51	34.51	34.47	34.51	1500.0
2009-04-30 06:00:00	QQQ	ETF	34.5	34.56	34.5	34.56	400.0
2009-04-30 06:30:00	QQQ	ETF	34.6	34.61	34.52	34.54	29933.0
2009-04-30 07:00:00	QQQ	ETF	34.56	34.58	34.51	34.51	355288.0
2009-04-30 07:30:00	QQQ	ETF	34.51	34.54	34.5	34.52	111944.0
2009-04-30 08:00:00	QQQ	ETF	34.51	34.52	34.4	34.42	623150.0
2009-04-30 08:30:00	QQQ	ETF	34.41	34.56	34.36	34.43	884252.0
2009-04-30 09:00:00	QQQ	ETF	34.43	34.43	34.29	34.38	1662301.0
2009-04-30 09:30:00	QQQ	ETF	34.38	34.66	34.3	34.62	16916859.0
2009-04-30 10:00:00	QQQ	ETF	34.63	34.86	34.615	34.8	11469282.0
2009-04-30 10:30:00	QQQ	ETF	34.8	34.83	34.67	34.8001	7559233.0
2009-04-30 11:00:00	QQQ	ETF	34.8022	34.9	34.78	34.83	8210678.0
2009-04-30 11:30:00	QQQ	ETF	34.83	34.88	34.69	34.71	6986253.0
2009-04-30 12:00:00	QQQ	ETF	34.71	34.75	34.62	34.7175	6604796.0
2009-04-30 12:30:00	QQQ	ETF	34.74	34.74	34.38	34.46	9919335.0

> showing 50 of 7,492 rows — these rows as CSV

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