PREVIEW / etf_30min / 2007-04-04

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-04-04.parquet
  size:    101 KB
  rows:    3,633

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
2007-04-04 06:30:00	SPY	ETF	143.75	143.75	143.75	143.75	1000.0
2007-04-04 07:00:00	SPY	ETF	143.74	143.74	143.68	143.71	79400.0
2007-04-04 07:30:00	SPY	ETF	143.72	143.79	143.72	143.74	41600.0
2007-04-04 08:00:00	SPY	ETF	143.71	143.85	143.53	143.64	1002700.0
2007-04-04 08:30:00	SPY	ETF	143.63	143.63	143.48	143.48	464700.0
2007-04-04 09:00:00	SPY	ETF	143.49	143.91	143.39	143.69	3620200.0
2007-04-04 09:30:00	SPY	ETF	143.69	143.81	143.44	143.63	10513892.0
2007-04-04 10:00:00	SPY	ETF	143.64	143.74	143.16	143.7	8929985.0
2007-04-04 10:30:00	SPY	ETF	143.69	143.8	143.49	143.62	4148050.0
2007-04-04 11:00:00	SPY	ETF	143.62	143.84	143.59	143.74	4135248.0
2007-04-04 11:30:00	SPY	ETF	143.73	143.8	143.65	143.75	2923454.0
2007-04-04 12:00:00	SPY	ETF	143.75	143.95	143.74	143.78	3989600.0
2007-04-04 12:30:00	SPY	ETF	143.79	143.85	143.75	143.84	1568100.0
2007-04-04 13:00:00	SPY	ETF	143.84	143.84	143.62	143.68	2779569.0
2007-04-04 13:30:00	SPY	ETF	143.68	143.72	143.54	143.7	3666900.0
2007-04-04 14:00:00	SPY	ETF	143.7	143.8	143.63	143.73	2273600.0
2007-04-04 14:30:00	SPY	ETF	143.74	143.82	143.43	143.75	2893850.0
2007-04-04 15:00:00	SPY	ETF	143.75	143.94	143.71	143.85	2927370.0
2007-04-04 15:30:00	SPY	ETF	143.86	143.91	143.76	143.79	4491605.0
2007-04-04 16:00:00	SPY	ETF	143.8	143.84	143.71	143.78	1477800.0
2007-04-04 16:30:00	SPY	ETF	143.78	143.83	143.78	143.83	1102800.0
2007-04-04 17:00:00	SPY	ETF	143.82	143.82	143.78	143.79	40500.0
2007-04-04 17:30:00	SPY	ETF	143.81	143.83	143.81	143.83	1900.0
2007-04-04 18:00:00	SPY	ETF	143.81	143.84	143.79	143.84	9400.0
2007-04-04 19:00:00	SPY	ETF	143.8	143.8	143.78	143.78	13100.0
2007-04-04 07:00:00	QQQ	ETF	44.22	44.22	44.17	44.19	36500.0
2007-04-04 07:30:00	QQQ	ETF	44.18	44.21	44.18	44.18	63300.0
2007-04-04 08:00:00	QQQ	ETF	44.2	44.24	44.13	44.21	529965.0
2007-04-04 08:30:00	QQQ	ETF	44.21	44.21	44.16	44.16	220791.0
2007-04-04 09:00:00	QQQ	ETF	44.17	44.31	44.13	44.19	2912919.0
2007-04-04 09:30:00	QQQ	ETF	44.2	44.29	44.13	44.24	12504200.0
2007-04-04 10:00:00	QQQ	ETF	44.24	44.29	44.13	44.28	16475300.0
2007-04-04 10:30:00	QQQ	ETF	44.28	44.3	44.16	44.23	6519400.0
2007-04-04 11:00:00	QQQ	ETF	44.22	44.33	44.21	44.31	6984300.0
2007-04-04 11:30:00	QQQ	ETF	44.3	44.31	44.26	44.28	3183500.0
2007-04-04 12:00:00	QQQ	ETF	44.28	44.38	44.28	44.33	7657800.0
2007-04-04 12:30:00	QQQ	ETF	44.32	44.34	44.3	44.33	1617900.0
2007-04-04 13:00:00	QQQ	ETF	44.34	44.34	44.17	44.26	3908700.0
2007-04-04 13:30:00	QQQ	ETF	44.26	44.26	44.18	44.22	4416000.0
2007-04-04 14:00:00	QQQ	ETF	44.22	44.27	44.19	44.25	1733400.0
2007-04-04 14:30:00	QQQ	ETF	44.24	44.28	44.22	44.26	1642800.0
2007-04-04 15:00:00	QQQ	ETF	44.25	44.29	44.23	44.28	2289200.0
2007-04-04 15:30:00	QQQ	ETF	44.28	44.3	44.25	44.3	4586800.0
2007-04-04 16:00:00	QQQ	ETF	44.29	44.36	44.28	44.33	2877770.0
2007-04-04 16:30:00	QQQ	ETF	44.33	44.36	44.3	44.35	4441026.0
2007-04-04 17:00:00	QQQ	ETF	44.35	44.36	44.33	44.35	257197.0
2007-04-04 17:30:00	QQQ	ETF	44.36	44.36	44.34	44.36	59200.0
2007-04-04 18:00:00	QQQ	ETF	44.35	44.35	44.34	44.34	3000.0
2007-04-04 18:30:00	QQQ	ETF	44.35	44.35	44.35	44.35	9650.0
2007-04-04 19:00:00	QQQ	ETF	44.34	44.36	44.34	44.36	7600.0

> showing 50 of 3,633 rows — these rows as CSV

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