PREVIEW / etf_30min / 2008-02-21

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-02-21.parquet
  size:    155 KB
  rows:    5,531

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-02-21 04:00:00	SPY	ETF	136.04	136.05	136.04	136.05	200.0
2008-02-21 05:00:00	SPY	ETF	136.26	136.26	136.26	136.26	100.0
2008-02-21 06:00:00	SPY	ETF	136.45	136.5	136.45	136.5	2000.0
2008-02-21 06:30:00	SPY	ETF	136.57	136.75	136.57	136.7	75500.0
2008-02-21 07:00:00	SPY	ETF	136.83	136.95	136.73	136.95	288500.0
2008-02-21 07:30:00	SPY	ETF	136.94	136.95	136.62	136.67	1583700.0
2008-02-21 08:00:00	SPY	ETF	136.65	136.92	135.85	136.65	2818500.0
2008-02-21 08:30:00	SPY	ETF	136.71	136.88	136.5	136.77	3932700.0
2008-02-21 09:00:00	SPY	ETF	136.74	136.75	136.56	136.68	863900.0
2008-02-21 09:30:00	SPY	ETF	136.66	137.01	136.46	136.67	21229316.0
2008-02-21 10:00:00	SPY	ETF	136.65	136.7	136.01	136.3	25699530.0
2008-02-21 10:30:00	SPY	ETF	136.31	136.4	135.0	135.47	15011916.0
2008-02-21 11:00:00	SPY	ETF	135.47	135.88	135.43	135.81	14179929.0
2008-02-21 11:30:00	SPY	ETF	135.81	136.16	135.8	136.05	8191304.0
2008-02-21 12:00:00	SPY	ETF	136.05	136.06	135.25	135.44	11605174.0
2008-02-21 12:30:00	SPY	ETF	135.44	135.61	135.22	135.459	9404936.0
2008-02-21 13:00:00	SPY	ETF	135.46	135.51	134.8	135.13	10426710.0
2008-02-21 13:30:00	SPY	ETF	135.13	135.14	134.65	134.96	8941110.0
2008-02-21 14:00:00	SPY	ETF	134.96	135.34	134.78	135.32	12881434.0
2008-02-21 14:30:00	SPY	ETF	135.32	135.38	134.76	134.89	8734275.0
2008-02-21 15:00:00	SPY	ETF	134.89	134.9	134.24	134.55	17717002.0
2008-02-21 15:30:00	SPY	ETF	134.56	134.74	134.07	134.48	19982449.0
2008-02-21 16:00:00	SPY	ETF	134.53	136.194	134.39	134.75	4226100.0
2008-02-21 16:30:00	SPY	ETF	134.74	134.74	134.63	134.65	346400.0
2008-02-21 17:00:00	SPY	ETF	134.63	134.64	134.46	134.57	132000.0
2008-02-21 17:30:00	SPY	ETF	134.58	134.63	134.56	134.56	17200.0
2008-02-21 18:00:00	SPY	ETF	134.56	134.56	134.45	134.49	29900.0
2008-02-21 18:30:00	SPY	ETF	134.45	134.55	134.45	134.55	7300.0
2008-02-21 19:00:00	SPY	ETF	134.52	134.6	134.52	134.57	1300.0
2008-02-21 19:30:00	SPY	ETF	134.57	134.59	134.47	134.47	19600.0
2008-02-21 06:30:00	QQQ	ETF	44.18	44.35	44.18	44.31	196800.0
2008-02-21 07:00:00	QQQ	ETF	44.3	44.43	44.29	44.43	264712.0
2008-02-21 07:30:00	QQQ	ETF	44.4	44.44	44.33	44.4	1074916.0
2008-02-21 08:00:00	QQQ	ETF	44.4	44.43	44.35	44.37	2539550.0
2008-02-21 08:30:00	QQQ	ETF	44.37	44.47	44.35	44.41	3553686.0
2008-02-21 09:00:00	QQQ	ETF	44.4	44.42	44.36	44.36	839494.0
2008-02-21 09:30:00	QQQ	ETF	44.36	44.47	44.25	44.35	19689940.0
2008-02-21 10:00:00	QQQ	ETF	44.35	44.4	44.13	44.29	10377374.0
2008-02-21 10:30:00	QQQ	ETF	44.3	44.32	43.86	43.87	11596605.0
2008-02-21 11:00:00	QQQ	ETF	43.86	43.98	43.82	43.92	11867797.0
2008-02-21 11:30:00	QQQ	ETF	43.91	44.02	43.88	43.9526	4839650.0
2008-02-21 12:00:00	QQQ	ETF	43.95	43.95	43.67	43.7599	5519571.0
2008-02-21 12:30:00	QQQ	ETF	43.76	43.8	43.63	43.8	5764207.0
2008-02-21 13:00:00	QQQ	ETF	43.79	43.81	43.65	43.79	6973512.0
2008-02-21 13:30:00	QQQ	ETF	43.79	43.79	43.54	43.62	6929975.0
2008-02-21 14:00:00	QQQ	ETF	43.62	43.8	43.6	43.78	6492966.0
2008-02-21 14:30:00	QQQ	ETF	43.79	43.81	43.58	43.65	5749198.0
2008-02-21 15:00:00	QQQ	ETF	43.65	43.65	43.39	43.5001	9349171.0
2008-02-21 15:30:00	QQQ	ETF	43.5	43.58	43.34	43.49	11967673.0
2008-02-21 16:00:00	QQQ	ETF	43.5	43.63	43.41	43.56	3889434.0

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

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