PREVIEW / etf_30min / 2008-04-03

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-04-03.parquet
  size:    154 KB
  rows:    5,616

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
2008-04-03 05:30:00	SPY	ETF	136.72	136.72	136.72	136.72	10000.0
2008-04-03 06:00:00	SPY	ETF	136.65	136.65	136.45	136.49	7900.0
2008-04-03 06:30:00	SPY	ETF	136.4	136.42	136.28	136.4	47800.0
2008-04-03 07:00:00	SPY	ETF	136.35	136.35	136.2	136.34	493100.0
2008-04-03 07:30:00	SPY	ETF	136.39	136.65	136.36	136.55	372200.0
2008-04-03 08:00:00	SPY	ETF	136.51	136.6	136.34	136.5	1365800.0
2008-04-03 08:30:00	SPY	ETF	136.45	136.7	135.72	135.79	7189738.0
2008-04-03 09:00:00	SPY	ETF	135.78	135.95	135.65	135.95	1544600.0
2008-04-03 09:30:00	SPY	ETF	135.94	136.27	135.71	136.24	18989679.0
2008-04-03 10:00:00	SPY	ETF	136.24	136.74	136.0	136.13	23540867.0
2008-04-03 10:30:00	SPY	ETF	136.13	136.3	135.862	135.902	8512504.0
2008-04-03 11:00:00	SPY	ETF	135.9	136.4	135.81	136.25	8411536.0
2008-04-03 11:30:00	SPY	ETF	136.24	136.71	136.18	136.57	7936829.0
2008-04-03 12:00:00	SPY	ETF	136.58	136.78	136.39	136.44	6589455.0
2008-04-03 12:30:00	SPY	ETF	136.44	137.21	136.36	137.01	11640270.0
2008-04-03 13:00:00	SPY	ETF	137.01	137.44	136.9	137.27	11347304.0
2008-04-03 13:30:00	SPY	ETF	137.28	137.33	136.86	136.86	9802359.0
2008-04-03 14:00:00	SPY	ETF	136.865	137.12	136.76	136.91	8296486.0
2008-04-03 14:30:00	SPY	ETF	136.91	137.25	136.68	137.23	12020521.0
2008-04-03 15:00:00	SPY	ETF	137.23	137.23	136.75	136.81	8357071.0
2008-04-03 15:30:00	SPY	ETF	136.81	136.95	136.39	136.79	19212781.0
2008-04-03 16:00:00	SPY	ETF	136.72	137.1	136.72	137.07	2763200.0
2008-04-03 16:30:00	SPY	ETF	137.05	137.13	136.98	137.0	1386100.0
2008-04-03 17:00:00	SPY	ETF	137.02	137.07	136.99	137.07	184200.0
2008-04-03 17:30:00	SPY	ETF	137.05	137.09	137.0	137.01	327100.0
2008-04-03 18:00:00	SPY	ETF	137.05	137.05	136.98	137.02	11300.0
2008-04-03 18:30:00	SPY	ETF	137.01	137.02	137.0	137.0	3300.0
2008-04-03 19:00:00	SPY	ETF	136.98	137.0	136.98	137.0	6900.0
2008-04-03 19:30:00	SPY	ETF	137.0	137.0	136.96	137.0	11600.0
2008-04-03 06:30:00	QQQ	ETF	45.45	45.45	45.45	45.45	2400.0
2008-04-03 07:00:00	QQQ	ETF	45.46	45.48	45.39	45.43	136797.0
2008-04-03 07:30:00	QQQ	ETF	45.45	45.6	45.45	45.52	561231.0
2008-04-03 08:00:00	QQQ	ETF	45.53	45.54	45.43	45.43	1883703.0
2008-04-03 08:30:00	QQQ	ETF	45.43	45.43	45.17	45.23	4341578.0
2008-04-03 09:00:00	QQQ	ETF	45.23	45.29	45.17	45.29	2680314.0
2008-04-03 09:30:00	QQQ	ETF	45.29	45.42	45.16	45.408	11351822.0
2008-04-03 10:00:00	QQQ	ETF	45.4	45.572	45.27	45.29	18713991.0
2008-04-03 10:30:00	QQQ	ETF	45.29	45.41	45.14	45.19	11288183.0
2008-04-03 11:00:00	QQQ	ETF	45.19	45.43	45.15	45.34	7452590.0
2008-04-03 11:30:00	QQQ	ETF	45.34	45.55	45.33	45.5	7349629.0
2008-04-03 12:00:00	QQQ	ETF	45.51	45.59	45.47	45.51	3975100.0
2008-04-03 12:30:00	QQQ	ETF	45.51	45.87	45.48	45.78	9814350.0
2008-04-03 13:00:00	QQQ	ETF	45.78	45.91	45.73	45.85	7748973.0
2008-04-03 13:30:00	QQQ	ETF	45.85	45.87	45.63	45.64	8380999.0
2008-04-03 14:00:00	QQQ	ETF	45.64	45.76	45.56	45.6701	6273908.0
2008-04-03 14:30:00	QQQ	ETF	45.68	45.83	45.575	45.81	6446935.0
2008-04-03 15:00:00	QQQ	ETF	45.82	45.82	45.67	45.7	3644883.0
2008-04-03 15:30:00	QQQ	ETF	45.69	45.73	45.5	45.59	12488502.0
2008-04-03 16:00:00	QQQ	ETF	45.59	45.81	45.58	45.8	3120242.0
2008-04-03 16:30:00	QQQ	ETF	45.78	45.84	45.76	45.76	487738.0

> showing 50 of 5,616 rows — these rows as CSV

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