PREVIEW / etf_30min / 2008-09-15

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-15.parquet
  size:    189 KB
  rows:    6,634

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-15 04:00:00	SPY	ETF	123.05	123.05	121.96	122.01	1300.0
2008-09-15 04:30:00	SPY	ETF	122.05	122.05	121.71	121.79	33500.0
2008-09-15 05:00:00	SPY	ETF	121.56	122.29	121.56	122.19	30000.0
2008-09-15 05:30:00	SPY	ETF	122.2	122.28	121.77	121.92	73210.0
2008-09-15 06:00:00	SPY	ETF	121.91	121.93	121.46	121.5	107254.0
2008-09-15 06:30:00	SPY	ETF	121.56	121.75	121.21	121.25	202500.0
2008-09-15 07:00:00	SPY	ETF	121.22	121.5	120.73	121.22	3563074.0
2008-09-15 07:30:00	SPY	ETF	121.21	121.57	121.1	121.33	2782029.0
2008-09-15 08:00:00	SPY	ETF	121.32	123.35	120.9501	121.86	14467504.0
2008-09-15 08:30:00	SPY	ETF	121.85	122.09	121.64	121.78	5639737.0
2008-09-15 09:00:00	SPY	ETF	121.77	121.9	121.35	121.83	5820071.0
2008-09-15 09:30:00	SPY	ETF	121.81	123.0	121.69	122.195	52469548.0
2008-09-15 10:00:00	SPY	ETF	122.18	123.16	122.0	123.02	35424290.0
2008-09-15 10:30:00	SPY	ETF	123.02	124.28	122.83	123.87	38379901.0
2008-09-15 11:00:00	SPY	ETF	123.87	125.652	122.92	122.95	20584346.0
2008-09-15 11:30:00	SPY	ETF	122.95	123.15	122.25	122.38	26697183.0
2008-09-15 12:00:00	SPY	ETF	122.38	123.71	122.3	123.07	28033981.0
2008-09-15 12:30:00	SPY	ETF	123.05	125.652	122.63	123.13	22767054.0
2008-09-15 13:00:00	SPY	ETF	123.13	123.52	122.65	122.78	16337498.0
2008-09-15 13:30:00	SPY	ETF	122.78	122.89	121.89	122.33	26259855.0
2008-09-15 14:00:00	SPY	ETF	122.302	125.652	122.12	122.4	24665904.0
2008-09-15 14:30:00	SPY	ETF	122.39	125.652	121.47	121.77	25153284.0
2008-09-15 15:00:00	SPY	ETF	121.78	121.95	120.51	120.81	35562004.0
2008-09-15 15:30:00	SPY	ETF	120.8	122.29	120.14	120.34	65420327.0
2008-09-15 16:00:00	SPY	ETF	120.37	123.12	119.75	120.02	12937353.0
2008-09-15 16:30:00	SPY	ETF	119.98	125.652	119.86	119.97	9042438.0
2008-09-15 17:00:00	SPY	ETF	119.99	120.25	119.99	120.04	163951.0
2008-09-15 17:30:00	SPY	ETF	120.01	120.15	119.95	120.0	4204250.0
2008-09-15 18:00:00	SPY	ETF	120.0	120.0	119.7	119.84	195987.0
2008-09-15 18:30:00	SPY	ETF	119.83	119.83	119.42	119.45	239717.0
2008-09-15 19:00:00	SPY	ETF	119.45	119.56	119.31	119.45	218991.0
2008-09-15 19:30:00	SPY	ETF	119.44	119.62	119.37	119.37	116325.0
2008-09-15 07:00:00	QQQ	ETF	42.41	42.57	42.22	42.57	1471057.0
2008-09-15 07:30:00	QQQ	ETF	42.57	42.57	42.37	42.37	918645.0
2008-09-15 08:00:00	QQQ	ETF	42.38	42.6	42.25	42.54	2247606.0
2008-09-15 08:30:00	QQQ	ETF	42.54	42.57	42.38	42.43	1913252.0
2008-09-15 09:00:00	QQQ	ETF	42.43	42.46	42.29	42.45	2932762.0
2008-09-15 09:30:00	QQQ	ETF	42.45	42.9	42.36	42.62	35235596.0
2008-09-15 10:00:00	QQQ	ETF	42.62	42.97	42.6	42.97	16738476.0
2008-09-15 10:30:00	QQQ	ETF	42.97	43.29	42.87	43.12	21064561.0
2008-09-15 11:00:00	QQQ	ETF	43.12	43.15	42.8	42.82	10998642.0
2008-09-15 11:30:00	QQQ	ETF	42.82	42.9999	42.3	42.7505	17019938.0
2008-09-15 12:00:00	QQQ	ETF	42.76	43.18	42.3	42.94	39353455.0
2008-09-15 12:30:00	QQQ	ETF	42.95	43.11	42.3	42.99	44916630.0
2008-09-15 13:00:00	QQQ	ETF	42.99	43.11	42.8	42.84	8050969.0
2008-09-15 13:30:00	QQQ	ETF	42.85	42.86	42.47	42.61	17767148.0
2008-09-15 14:00:00	QQQ	ETF	42.61	42.85	42.52	42.65	12648471.0
2008-09-15 14:30:00	QQQ	ETF	42.65	42.72	42.42	42.49	12590201.0
2008-09-15 15:00:00	QQQ	ETF	42.49	42.52	42.09	42.23	23130680.0
2008-09-15 15:30:00	QQQ	ETF	42.22	42.6	42.03	42.09	39438153.0

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

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