PREVIEW / etf_30min / 2007-01-23

all etf 30-min files

  file:    by_date/etf_30min/2007/2007-01-23.parquet
  size:    97 KB
  rows:    3,371

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-01-23 06:00:00	SPY	ETF	142.18	142.18	142.18	142.18	19900.0
2007-01-23 07:00:00	SPY	ETF	142.17	142.22	142.15	142.15	135900.0
2007-01-23 07:30:00	SPY	ETF	142.15	142.2	142.15	142.16	6500.0
2007-01-23 08:00:00	SPY	ETF	142.22	142.26	142.14	142.26	298500.0
2007-01-23 08:30:00	SPY	ETF	142.25	142.3	142.21	142.21	130800.0
2007-01-23 09:00:00	SPY	ETF	142.22	142.31	142.19	142.25	224900.0
2007-01-23 09:30:00	SPY	ETF	142.26	142.52	142.06	142.41	6377700.0
2007-01-23 10:00:00	SPY	ETF	142.4	142.49	142.22	142.32	5047200.0
2007-01-23 10:30:00	SPY	ETF	142.32	142.45	142.26	142.34	3098400.0
2007-01-23 11:00:00	SPY	ETF	142.34	142.78	142.32	142.72	7532700.0
2007-01-23 11:30:00	SPY	ETF	142.73	142.76	142.6	142.73	1531000.0
2007-01-23 12:00:00	SPY	ETF	142.74	142.77	142.64	142.75	2256500.0
2007-01-23 12:30:00	SPY	ETF	142.74	143.02	142.68	142.96	3440200.0
2007-01-23 13:00:00	SPY	ETF	142.97	143.08	142.93	143.04	2989000.0
2007-01-23 13:30:00	SPY	ETF	143.04	143.05	142.9	142.95	1405000.0
2007-01-23 14:00:00	SPY	ETF	142.95	143.0	142.73	142.79	5381000.0
2007-01-23 14:30:00	SPY	ETF	142.78	142.79	142.43	142.67	6439700.0
2007-01-23 15:00:00	SPY	ETF	142.67	142.79	142.63	142.68	2064700.0
2007-01-23 15:30:00	SPY	ETF	142.68	142.75	142.58	142.75	3413300.0
2007-01-23 16:00:00	SPY	ETF	142.74	142.92	142.6822	142.84	560800.0
2007-01-23 16:30:00	SPY	ETF	142.81	142.83	142.77	142.81	82100.0
2007-01-23 17:00:00	SPY	ETF	142.84	142.97	142.8	142.96	779500.0
2007-01-23 17:30:00	SPY	ETF	142.9	142.97	142.88	142.97	4000.0
2007-01-23 18:00:00	SPY	ETF	142.94	142.95	142.88	142.88	12100.0
2007-01-23 18:30:00	SPY	ETF	142.93	142.93	142.93	142.93	1000.0
2007-01-23 19:00:00	SPY	ETF	142.96	142.96	142.96	142.96	800.0
2007-01-23 19:30:00	SPY	ETF	142.9	142.93	142.9	142.93	13000.0
2007-01-23 06:30:00	QQQ	ETF	43.6	43.6	43.6	43.6	61400.0
2007-01-23 07:00:00	QQQ	ETF	43.63	43.67	43.61	43.61	66200.0
2007-01-23 07:30:00	QQQ	ETF	43.62	43.62	43.6	43.62	50900.0
2007-01-23 08:00:00	QQQ	ETF	43.64	43.64	43.6	43.63	1251645.0
2007-01-23 08:30:00	QQQ	ETF	43.63	43.66	43.62	43.63	553665.0
2007-01-23 09:00:00	QQQ	ETF	43.64	43.69	43.6	43.65	1088911.0
2007-01-23 09:30:00	QQQ	ETF	43.64	43.89	43.62	43.85	20130900.0
2007-01-23 10:00:00	QQQ	ETF	43.85	43.88	43.69	43.75	10303600.0
2007-01-23 10:30:00	QQQ	ETF	43.74	43.8	43.7	43.76	4702100.0
2007-01-23 11:00:00	QQQ	ETF	43.75	43.92	43.75	43.89	12810700.0
2007-01-23 11:30:00	QQQ	ETF	43.89	43.92	43.8	43.9	6492800.0
2007-01-23 12:00:00	QQQ	ETF	43.9	43.91	43.82	43.87	4880400.0
2007-01-23 12:30:00	QQQ	ETF	43.87	43.94	43.83	43.89	9756500.0
2007-01-23 13:00:00	QQQ	ETF	43.9	43.98	43.88	43.94	6122000.0
2007-01-23 13:30:00	QQQ	ETF	43.95	43.95	43.84	43.86	4246700.0
2007-01-23 14:00:00	QQQ	ETF	43.87	43.88	43.68	43.72	12660100.0
2007-01-23 14:30:00	QQQ	ETF	43.72	43.75	43.5	43.66	15143700.0
2007-01-23 15:00:00	QQQ	ETF	43.65	43.69	43.57	43.62	5362000.0
2007-01-23 15:30:00	QQQ	ETF	43.61	43.66	43.57	43.58	8998400.0
2007-01-23 16:00:00	QQQ	ETF	43.57	43.69	43.57	43.58	1414056.0
2007-01-23 16:30:00	QQQ	ETF	43.58	43.64	43.54	43.63	1349712.0
2007-01-23 17:00:00	QQQ	ETF	43.63	43.74	43.6	43.74	706390.0
2007-01-23 17:30:00	QQQ	ETF	43.7	43.76	43.7	43.76	1188490.0

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

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