PREVIEW / etf_30min / 2008-09-12

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-12.parquet
  size:    171 KB
  rows:    5,961

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
2008-09-12 04:30:00	SPY	ETF	125.48	125.48	125.48	125.48	100.0
2008-09-12 05:00:00	SPY	ETF	125.74	125.74	125.74	125.74	100.0
2008-09-12 05:30:00	SPY	ETF	125.55	125.61	125.55	125.61	2300.0
2008-09-12 06:00:00	SPY	ETF	125.48	125.48	125.46	125.48	25000.0
2008-09-12 06:30:00	SPY	ETF	125.26	125.46	125.12	125.46	48000.0
2008-09-12 07:00:00	SPY	ETF	125.51	125.51	125.08	125.25	473347.0
2008-09-12 07:30:00	SPY	ETF	125.22	125.31	124.97	125.02	325743.0
2008-09-12 08:00:00	SPY	ETF	125.02	125.71	124.77	124.89	2178974.0
2008-09-12 08:30:00	SPY	ETF	124.89	124.94	124.47	124.53	4417550.0
2008-09-12 09:00:00	SPY	ETF	124.53	125.2	124.24	124.3	2810110.0
2008-09-12 09:30:00	SPY	ETF	124.29	124.65	123.83	124.18	38479616.0
2008-09-12 10:00:00	SPY	ETF	124.18	125.04	123.97	124.78	26594542.0
2008-09-12 10:30:00	SPY	ETF	124.78	125.1	124.45	125.05	17187266.0
2008-09-12 11:00:00	SPY	ETF	125.06	125.98	124.91	125.73	26275840.0
2008-09-12 11:30:00	SPY	ETF	125.72	125.73	125.12	125.36	16216442.0
2008-09-12 12:00:00	SPY	ETF	125.37	125.64	125.17	125.3	12955532.0
2008-09-12 12:30:00	SPY	ETF	125.31	125.43	124.58	124.61	13828372.0
2008-09-12 13:00:00	SPY	ETF	124.6	125.14	124.45	125.05	18129984.0
2008-09-12 13:30:00	SPY	ETF	125.05	125.43	124.77	125.4299	15847652.0
2008-09-12 14:00:00	SPY	ETF	125.42	125.44	124.87	124.99	14178776.0
2008-09-12 14:30:00	SPY	ETF	124.98	125.95	124.79	125.85	16621527.0
2008-09-12 15:00:00	SPY	ETF	125.85	125.98	125.37	125.62	17544343.0
2008-09-12 15:30:00	SPY	ETF	125.61	125.78	124.97	125.75	29301786.0
2008-09-12 16:00:00	SPY	ETF	125.76	126.25	125.387	126.25	13858134.0
2008-09-12 16:30:00	SPY	ETF	126.21	126.26	126.09	126.25	1026328.0
2008-09-12 17:00:00	SPY	ETF	126.27	126.27	125.87	126.0	891724.0
2008-09-12 17:30:00	SPY	ETF	126.0	126.09	125.4	125.51	4131647.0
2008-09-12 18:00:00	SPY	ETF	125.51	125.75	125.39	125.64	191184.0
2008-09-12 18:30:00	SPY	ETF	125.62	125.85	125.62	125.75	16825.0
2008-09-12 19:00:00	SPY	ETF	125.77	125.9	125.7	125.87	26207.0
2008-09-12 19:30:00	SPY	ETF	125.87	125.95	125.83	125.92	55627.0
2008-09-12 06:00:00	QQQ	ETF	43.6	43.6	43.6	43.6	200.0
2008-09-12 06:30:00	QQQ	ETF	43.55	43.55	43.52	43.52	800.0
2008-09-12 07:00:00	QQQ	ETF	43.56	43.7	43.56	43.69	15457.0
2008-09-12 07:30:00	QQQ	ETF	43.7	43.71	43.59	43.62	1367924.0
2008-09-12 08:00:00	QQQ	ETF	43.61	43.62	43.55	43.6	546883.0
2008-09-12 08:30:00	QQQ	ETF	43.61	43.67	43.32	43.35	1529903.0
2008-09-12 09:00:00	QQQ	ETF	43.34	43.36	43.24	43.24	1414694.0
2008-09-12 09:30:00	QQQ	ETF	43.23	43.28	42.91	42.97	30988629.0
2008-09-12 10:00:00	QQQ	ETF	42.97	43.27	42.9	43.11	18643644.0
2008-09-12 10:30:00	QQQ	ETF	43.12	43.18	42.97	43.12	10197321.0
2008-09-12 11:00:00	QQQ	ETF	43.13	43.71	43.05	43.58	22341673.0
2008-09-12 11:30:00	QQQ	ETF	43.58	43.585	43.301	43.42	9753451.0
2008-09-12 12:00:00	QQQ	ETF	43.42	43.52	43.33	43.39	7010511.0
2008-09-12 12:30:00	QQQ	ETF	43.39	43.45	43.06	43.11	7889696.0
2008-09-12 13:00:00	QQQ	ETF	43.1	43.3	43.02	43.25	8058617.0
2008-09-12 13:30:00	QQQ	ETF	43.26	43.38	43.13	43.35	6150286.0
2008-09-12 14:00:00	QQQ	ETF	43.36	43.44	43.14	43.3	7075054.0
2008-09-12 14:30:00	QQQ	ETF	43.3	43.6112	43.22	43.59	9139315.0
2008-09-12 15:00:00	QQQ	ETF	43.59	43.65	43.37	43.47	11250873.0

> showing 50 of 5,961 rows — these rows as CSV

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