PREVIEW / etf_30min / 2008-07-15

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-07-15.parquet
  size:    184 KB
  rows:    6,184

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-07-15 04:00:00	SPY	ETF	121.89	121.9	121.85	121.85	1400.0
2008-07-15 04:30:00	SPY	ETF	121.81	121.81	121.81	121.81	100.0
2008-07-15 05:30:00	SPY	ETF	121.83	121.83	121.65	121.65	1300.0
2008-07-15 06:00:00	SPY	ETF	121.58	121.65	121.55	121.61	185500.0
2008-07-15 06:30:00	SPY	ETF	121.6	121.6	121.04	121.17	1135900.0
2008-07-15 07:00:00	SPY	ETF	121.19	121.36	121.14	121.26	825708.0
2008-07-15 07:30:00	SPY	ETF	121.32	121.47	121.2	121.4	934957.0
2008-07-15 08:00:00	SPY	ETF	121.4	121.56	121.22	121.31	2252910.0
2008-07-15 08:30:00	SPY	ETF	121.26	121.7	121.06	121.69	5687287.0
2008-07-15 09:00:00	SPY	ETF	121.68	122.0	121.53	121.82	4068440.0
2008-07-15 09:30:00	SPY	ETF	121.8	121.83	120.97	121.09	39741932.0
2008-07-15 10:00:00	SPY	ETF	121.1	121.15	120.02	120.62	66039786.0
2008-07-15 10:30:00	SPY	ETF	120.62	121.3	120.33	121.0699	33371027.0
2008-07-15 11:00:00	SPY	ETF	121.065	122.37	121.06	121.53	70919556.0
2008-07-15 11:30:00	SPY	ETF	121.47	122.24	121.08	122.11	30711924.0
2008-07-15 12:00:00	SPY	ETF	122.11	122.48	121.69	122.31	30684614.0
2008-07-15 12:30:00	SPY	ETF	122.31	122.89	122.26	122.71	33097209.0
2008-07-15 13:00:00	SPY	ETF	122.72	123.35	122.12	122.3	32484963.0
2008-07-15 13:30:00	SPY	ETF	122.3	122.8	122.05	122.58	18523256.0
2008-07-15 14:00:00	SPY	ETF	122.58	122.77	122.1	122.6	20091937.0
2008-07-15 14:30:00	SPY	ETF	122.6	123.44	122.5	122.95	19765913.0
2008-07-15 15:00:00	SPY	ETF	122.95	123.49	122.22	122.43	36183077.0
2008-07-15 15:30:00	SPY	ETF	122.43	122.66	121.41	121.45	34652404.0
2008-07-15 16:00:00	SPY	ETF	121.39	122.8052	120.46	121.12	6299272.0
2008-07-15 16:30:00	SPY	ETF	121.12	122.8119	121.12	121.29	9258778.0
2008-07-15 17:00:00	SPY	ETF	121.29	121.31	121.16	121.22	1167279.0
2008-07-15 17:30:00	SPY	ETF	121.21	121.25	121.1	121.1	49600.0
2008-07-15 18:00:00	SPY	ETF	121.11	121.13	120.99	121.09	36350.0
2008-07-15 18:30:00	SPY	ETF	121.09	121.22	121.09	121.22	30620.0
2008-07-15 19:00:00	SPY	ETF	121.2	121.32	121.2	121.31	20977.0
2008-07-15 19:30:00	SPY	ETF	121.31	121.4	121.3	121.4	15915.0
2008-07-15 04:00:00	QQQ	ETF	43.9	43.9	43.84	43.84	2400.0
2008-07-15 04:30:00	QQQ	ETF	43.86	43.86	43.85	43.85	300.0
2008-07-15 05:00:00	QQQ	ETF	43.85	43.85	43.85	43.85	2000.0
2008-07-15 05:30:00	QQQ	ETF	43.81	43.81	43.81	43.81	100.0
2008-07-15 06:00:00	QQQ	ETF	43.81	43.81	43.77	43.77	300.0
2008-07-15 06:30:00	QQQ	ETF	43.79	43.8	43.58	43.67	11700.0
2008-07-15 07:00:00	QQQ	ETF	43.7	43.74	43.68	43.73	63399.0
2008-07-15 07:30:00	QQQ	ETF	43.79	43.8	43.74	43.77	301304.0
2008-07-15 08:00:00	QQQ	ETF	43.78	43.84	43.76	43.81	525946.0
2008-07-15 08:30:00	QQQ	ETF	43.81	44.0	43.72	43.98	2147955.0
2008-07-15 09:00:00	QQQ	ETF	43.98	44.09	43.89	44.01	2371181.0
2008-07-15 09:30:00	QQQ	ETF	44.02	44.03	43.63	43.768	25034448.0
2008-07-15 10:00:00	QQQ	ETF	43.76	43.77	43.3	43.57	37759202.0
2008-07-15 10:30:00	QQQ	ETF	43.56	43.83	43.44	43.71	17860424.0
2008-07-15 11:00:00	QQQ	ETF	43.72	44.3	43.6	43.92	38974338.0
2008-07-15 11:30:00	QQQ	ETF	43.92	44.25	43.69	44.14	21147049.0
2008-07-15 12:00:00	QQQ	ETF	44.15	44.42	44.04	44.38	22164466.0
2008-07-15 12:30:00	QQQ	ETF	44.38	44.62	44.3	44.52	15639482.0
2008-07-15 13:00:00	QQQ	ETF	44.5204	44.72	44.26	44.3186	16730056.0

> showing 50 of 6,184 rows — these rows as CSV

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