PREVIEW / etf_30min / 2009-12-22

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-12-22.parquet
  size:    233 KB
  rows:    7,969

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
2009-12-22 04:30:00	SPY	ETF	111.48	111.55	111.48	111.55	200.0
2009-12-22 05:30:00	SPY	ETF	111.68	111.68	111.6	111.64	3000.0
2009-12-22 06:00:00	SPY	ETF	111.6	111.6	111.6	111.6	100.0
2009-12-22 06:30:00	SPY	ETF	111.6	111.6	111.6	111.6	3500.0
2009-12-22 07:00:00	SPY	ETF	111.63	111.82	111.61	111.76	102364.0
2009-12-22 07:30:00	SPY	ETF	111.78	111.82	111.62	111.66	96055.0
2009-12-22 08:00:00	SPY	ETF	111.66	111.75	111.19	111.68	798200.0
2009-12-22 08:30:00	SPY	ETF	111.68	111.68	111.39	111.52	1635686.0
2009-12-22 09:00:00	SPY	ETF	111.54	111.61	111.54	111.56	518674.0
2009-12-22 09:30:00	SPY	ETF	111.57	111.85	111.46	111.65	12286364.0
2009-12-22 10:00:00	SPY	ETF	111.65	111.97	111.57	111.89	13088356.0
2009-12-22 10:30:00	SPY	ETF	111.89	111.89	111.58	111.62	6937558.0
2009-12-22 11:00:00	SPY	ETF	111.62	111.72	111.51	111.56	5902018.0
2009-12-22 11:30:00	SPY	ETF	111.55	111.61	111.425	111.6	4562516.0
2009-12-22 12:00:00	SPY	ETF	111.59	111.65	111.56	111.64	2496783.0
2009-12-22 12:30:00	SPY	ETF	111.63	111.79	111.62	111.75	3577793.0
2009-12-22 13:00:00	SPY	ETF	111.76	111.87	111.71	111.79	6346304.0
2009-12-22 13:30:00	SPY	ETF	111.78	111.89	111.76	111.83	5031070.0
2009-12-22 14:00:00	SPY	ETF	111.83	111.85	111.6	111.74	3803982.0
2009-12-22 14:30:00	SPY	ETF	111.74	111.79	111.7	111.7	3226610.0
2009-12-22 15:00:00	SPY	ETF	111.71	111.715	111.6	111.68	4943426.0
2009-12-22 15:30:00	SPY	ETF	111.68	111.76	111.62	111.72	10367233.0
2009-12-22 16:00:00	SPY	ETF	111.73	111.87	111.63	111.72	3089378.0
2009-12-22 16:30:00	SPY	ETF	111.73	111.77	111.72	111.73	954414.0
2009-12-22 17:00:00	SPY	ETF	111.73	111.75	111.69	111.72	75097.0
2009-12-22 17:30:00	SPY	ETF	111.73	111.75	111.69	111.7	29761.0
2009-12-22 18:00:00	SPY	ETF	111.7	111.72	111.7	111.72	2900.0
2009-12-22 18:30:00	SPY	ETF	111.71	111.72	111.7	111.72	5825.0
2009-12-22 19:00:00	SPY	ETF	111.73	111.73	111.71	111.71	6425.0
2009-12-22 19:30:00	SPY	ETF	111.71	111.81	111.71	111.77	20094.0
2009-12-22 05:00:00	QQQ	ETF	45.2	45.2	45.18	45.18	2520.0
2009-12-22 05:30:00	QQQ	ETF	45.2	45.2	45.17	45.19	1000.0
2009-12-22 07:00:00	QQQ	ETF	45.15	45.22	45.15	45.17	129250.0
2009-12-22 07:30:00	QQQ	ETF	45.18	45.19	45.15	45.15	27347.0
2009-12-22 08:00:00	QQQ	ETF	45.15	45.19	44.93	45.13	891538.0
2009-12-22 08:30:00	QQQ	ETF	45.13	45.14	45.0	45.11	846463.0
2009-12-22 09:00:00	QQQ	ETF	45.11	45.11	45.07	45.08	935872.0
2009-12-22 09:30:00	QQQ	ETF	45.07	45.25	45.03	45.17	8356607.0
2009-12-22 10:00:00	QQQ	ETF	45.17	45.28	45.12	45.25	6177881.0
2009-12-22 10:30:00	QQQ	ETF	45.26	45.26	45.13	45.15	4364245.0
2009-12-22 11:00:00	QQQ	ETF	45.14	45.17	45.08	45.0924	2747367.0
2009-12-22 11:30:00	QQQ	ETF	45.095	45.14	45.05	45.13	1505578.0
2009-12-22 12:00:00	QQQ	ETF	45.131	45.16	45.11	45.15	1256287.0
2009-12-22 12:30:00	QQQ	ETF	45.155	45.225	45.15	45.2074	1783309.0
2009-12-22 13:00:00	QQQ	ETF	45.205	45.29	45.19	45.2383	4497841.0
2009-12-22 13:30:00	QQQ	ETF	45.2375	45.27	45.21	45.24	2502419.0
2009-12-22 14:00:00	QQQ	ETF	45.235	45.24	45.17	45.19	2696559.0
2009-12-22 14:30:00	QQQ	ETF	45.18	45.24	45.18	45.2	1079421.0
2009-12-22 15:00:00	QQQ	ETF	45.205	45.23	45.16	45.22	1537498.0
2009-12-22 15:30:00	QQQ	ETF	45.21	45.26	45.2	45.22	5660175.0

> showing 50 of 7,969 rows — these rows as CSV

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