PREVIEW / etf_30min / 2009-09-22

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-22.parquet
  size:    228 KB
  rows:    7,632

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-09-22 04:00:00	SPY	ETF	107.22	107.25	107.22	107.25	1625.0
2009-09-22 05:00:00	SPY	ETF	107.15	107.16	107.15	107.16	2100.0
2009-09-22 05:30:00	SPY	ETF	107.17	107.19	107.17	107.19	4500.0
2009-09-22 06:00:00	SPY	ETF	107.19	107.3	107.19	107.26	44600.0
2009-09-22 06:30:00	SPY	ETF	107.24	107.34	107.19	107.27	6550.0
2009-09-22 07:00:00	SPY	ETF	107.26	107.28	107.16	107.23	171299.0
2009-09-22 07:30:00	SPY	ETF	107.24	107.29	107.17	107.21	366910.0
2009-09-22 08:00:00	SPY	ETF	107.21	107.37	107.1	107.12	517808.0
2009-09-22 08:30:00	SPY	ETF	107.13	107.18	107.08	107.08	865434.0
2009-09-22 09:00:00	SPY	ETF	107.08	107.25	106.98	107.08	1668657.0
2009-09-22 09:30:00	SPY	ETF	107.08	107.11	106.78	106.83	20456281.0
2009-09-22 10:00:00	SPY	ETF	106.83	107.05	106.61	106.9001	13327751.0
2009-09-22 10:30:00	SPY	ETF	106.9	106.94	106.6	106.83	8385481.0
2009-09-22 11:00:00	SPY	ETF	106.83	107.11	106.83	106.96	6288019.0
2009-09-22 11:30:00	SPY	ETF	106.96	107.08	106.86	107.0775	4312998.0
2009-09-22 12:00:00	SPY	ETF	107.0701	107.34	107.0	107.28	8613496.0
2009-09-22 12:30:00	SPY	ETF	107.28	107.35	107.0	107.1785	6280474.0
2009-09-22 13:00:00	SPY	ETF	107.18	107.37	106.99	107.08	10739018.0
2009-09-22 13:30:00	SPY	ETF	107.09	107.18	106.96	107.09	4390388.0
2009-09-22 14:00:00	SPY	ETF	107.1	107.2	107.03	107.13	3702664.0
2009-09-22 14:30:00	SPY	ETF	107.14	107.25	107.01	107.23	7620012.0
2009-09-22 15:00:00	SPY	ETF	107.23	107.25	107.0	107.19	11893514.0
2009-09-22 15:30:00	SPY	ETF	107.2	107.31	107.01	107.1	13364896.0
2009-09-22 16:00:00	SPY	ETF	107.09	107.2332	106.71	107.17	9189980.0
2009-09-22 16:30:00	SPY	ETF	107.16	107.16	107.09	107.15	180627.0
2009-09-22 17:00:00	SPY	ETF	107.15	107.15	107.1	107.11	135876.0
2009-09-22 17:30:00	SPY	ETF	107.12	107.14	107.03	107.09	159360.0
2009-09-22 18:00:00	SPY	ETF	107.09	107.21	107.08	107.2	226891.0
2009-09-22 18:30:00	SPY	ETF	107.21	107.26	107.17	107.26	62562.0
2009-09-22 19:00:00	SPY	ETF	107.22	107.23	107.17	107.22	61180.0
2009-09-22 19:30:00	SPY	ETF	107.23	107.26	107.19	107.24	17700.0
2009-09-22 04:00:00	QQQ	ETF	42.84	42.86	42.84	42.85	22225.0
2009-09-22 04:30:00	QQQ	ETF	42.84	42.84	42.84	42.84	29900.0
2009-09-22 05:00:00	QQQ	ETF	42.83	42.83	42.83	42.83	12500.0
2009-09-22 05:30:00	QQQ	ETF	42.85	42.85	42.85	42.85	19000.0
2009-09-22 06:00:00	QQQ	ETF	42.87	42.87	42.85	42.86	35000.0
2009-09-22 06:30:00	QQQ	ETF	42.84	42.87	42.84	42.87	21600.0
2009-09-22 07:00:00	QQQ	ETF	42.86	42.86	42.78	42.82	125016.0
2009-09-22 07:30:00	QQQ	ETF	42.82	42.86	42.79	42.82	333020.0
2009-09-22 08:00:00	QQQ	ETF	42.82	42.9	42.8	42.82	367566.0
2009-09-22 08:30:00	QQQ	ETF	42.81	42.81	42.77	42.77	374016.0
2009-09-22 09:00:00	QQQ	ETF	42.78	42.86	42.76	42.82	1390680.0
2009-09-22 09:30:00	QQQ	ETF	42.82	42.83	42.4398	42.62	13501250.0
2009-09-22 10:00:00	QQQ	ETF	42.62	42.72	42.55	42.64	7743764.0
2009-09-22 10:30:00	QQQ	ETF	42.63	42.7	42.49	42.57	7906634.0
2009-09-22 11:00:00	QQQ	ETF	42.56	42.7	42.56	42.65	2393307.0
2009-09-22 11:30:00	QQQ	ETF	42.65	42.68	42.6	42.68	2042504.0
2009-09-22 12:00:00	QQQ	ETF	42.68	42.77	42.68	42.73	4910126.0
2009-09-22 12:30:00	QQQ	ETF	42.735	42.76	42.65	42.68	3192887.0
2009-09-22 13:00:00	QQQ	ETF	42.6799	42.75	42.58	42.62	4285075.0

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

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