PREVIEW / etf_30min / 2006-08-07

all etf 30-min files

  file:    by_date/etf_30min/2006/2006-08-07.parquet
  size:    74 KB
  rows:    2,690

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
2006-08-07 05:00:00	SPY	ETF	127.54	127.68	127.54	127.68	1900.0
2006-08-07 07:00:00	SPY	ETF	127.68	127.7	127.68	127.69	12000.0
2006-08-07 07:30:00	SPY	ETF	127.7	127.76	127.65	127.73	32800.0
2006-08-07 08:00:00	SPY	ETF	127.75	128.2	127.66	127.78	358100.0
2006-08-07 08:30:00	SPY	ETF	127.79	127.86	127.74	127.86	190500.0
2006-08-07 09:00:00	SPY	ETF	127.85	127.9	127.68	127.87	365400.0
2006-08-07 09:30:00	SPY	ETF	127.9	127.96	127.64	127.88	5325700.0
2006-08-07 10:00:00	SPY	ETF	127.88	128.01	127.76	127.84	3487200.0
2006-08-07 10:30:00	SPY	ETF	127.83	127.9	127.67	127.68	2203900.0
2006-08-07 11:00:00	SPY	ETF	127.68	127.77	127.53	127.57	4802700.0
2006-08-07 11:30:00	SPY	ETF	127.56	127.78	127.53	127.78	1405900.0
2006-08-07 12:00:00	SPY	ETF	127.78	127.85	127.64	127.74	2173500.0
2006-08-07 12:30:00	SPY	ETF	127.73	128.05	127.72	127.8278	3281100.0
2006-08-07 13:00:00	SPY	ETF	127.8	127.97	127.75	127.95	1876400.0
2006-08-07 13:30:00	SPY	ETF	127.95	128.08	127.78	127.79	2694600.0
2006-08-07 14:00:00	SPY	ETF	127.78	127.83	127.57	127.6	1942900.0
2006-08-07 14:30:00	SPY	ETF	127.6	127.75	127.56	127.67	2965300.0
2006-08-07 15:00:00	SPY	ETF	127.66	127.71	127.4	127.59	4229900.0
2006-08-07 15:30:00	SPY	ETF	127.59	127.78	127.59	127.76	3738500.0
2006-08-07 16:00:00	SPY	ETF	127.76	127.95	127.67	127.89	2580400.0
2006-08-07 16:30:00	SPY	ETF	127.89	127.95	127.88	127.95	1018800.0
2006-08-07 17:00:00	SPY	ETF	127.9	127.94	127.89	127.89	6300.0
2006-08-07 17:30:00	SPY	ETF	127.88	127.9	127.88	127.88	4600.0
2006-08-07 18:00:00	SPY	ETF	127.88	127.95	127.88	127.95	2000.0
2006-08-07 18:30:00	SPY	ETF	127.95	127.96	127.95	127.96	53500.0
2006-08-07 19:30:00	SPY	ETF	127.97	127.97	127.91	127.91	300.0
2006-08-07 09:30:00	QQQ	ETF	36.92	36.94	36.75	36.87	10380300.0
2006-08-07 10:00:00	QQQ	ETF	36.87	36.91	36.79	36.81	4758000.0
2006-08-07 10:30:00	QQQ	ETF	36.8	36.82	36.75	36.77	4735800.0
2006-08-07 11:00:00	QQQ	ETF	36.76	36.77	36.63	36.69	6898000.0
2006-08-07 11:30:00	QQQ	ETF	36.68	36.82	36.65	36.81	3989800.0
2006-08-07 12:00:00	QQQ	ETF	36.82	36.84	36.74	36.75	1904700.0
2006-08-07 12:30:00	QQQ	ETF	36.75	36.88	36.74	36.79	2995500.0
2006-08-07 13:00:00	QQQ	ETF	36.8	36.87	36.76	36.86	2178100.0
2006-08-07 13:30:00	QQQ	ETF	36.86	36.92	36.79	36.79	3559900.0
2006-08-07 14:00:00	QQQ	ETF	36.79	36.8	36.62	36.64	4844800.0
2006-08-07 14:30:00	QQQ	ETF	36.64	36.68	36.59	36.63	6005300.0
2006-08-07 15:00:00	QQQ	ETF	36.64	36.72	36.53	36.66	7179700.0
2006-08-07 15:30:00	QQQ	ETF	36.66	36.75	36.65	36.71	5971800.0
2006-08-07 08:00:00	IWM	ETF	69.25	69.62	69.25	69.37	520200.0
2006-08-07 08:30:00	IWM	ETF	69.36	69.36	69.28	69.31	48000.0
2006-08-07 09:00:00	IWM	ETF	69.31	69.4	69.29	69.37	398400.0
2006-08-07 09:30:00	IWM	ETF	69.37	69.4	68.96	69.18	4966100.0
2006-08-07 10:00:00	IWM	ETF	69.2	69.41	69.08	69.21	3169600.0
2006-08-07 10:30:00	IWM	ETF	69.2	69.25	69.02	69.04	3470200.0
2006-08-07 11:00:00	IWM	ETF	69.03	69.05	68.74	68.81	7121400.0
2006-08-07 11:30:00	IWM	ETF	68.82	69.11	68.78	69.1099	2629900.0
2006-08-07 12:00:00	IWM	ETF	69.11	69.17	69.05	69.15	1148700.0
2006-08-07 12:30:00	IWM	ETF	69.16	69.44	69.16	69.26	3007900.0
2006-08-07 13:00:00	IWM	ETF	69.27	69.41	69.2	69.38	1266900.0

> showing 50 of 2,690 rows — these rows as CSV

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