PREVIEW / etf_30min / 2008-09-10

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-10.parquet
  size:    173 KB
  rows:    6,085

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-10 04:00:00	SPY	ETF	124.11	124.42	124.11	124.42	2300.0
2008-09-10 05:00:00	SPY	ETF	123.79	123.79	123.79	123.79	1000.0
2008-09-10 05:30:00	SPY	ETF	123.78	123.78	123.68	123.68	5200.0
2008-09-10 06:00:00	SPY	ETF	123.64	124.16	123.64	124.03	139900.0
2008-09-10 06:30:00	SPY	ETF	124.06	124.09	123.73	123.84	46900.0
2008-09-10 07:00:00	SPY	ETF	123.83	124.2	123.8	124.06	701486.0
2008-09-10 07:30:00	SPY	ETF	124.08	124.4	122.58	122.68	6748528.0
2008-09-10 08:00:00	SPY	ETF	122.67	124.13	122.47	123.51	7087177.0
2008-09-10 08:30:00	SPY	ETF	123.5	123.92	123.24	123.9	4749597.0
2008-09-10 09:00:00	SPY	ETF	123.89	124.0	123.5	123.88	2689264.0
2008-09-10 09:30:00	SPY	ETF	123.89	124.19	123.18	123.9	34733972.0
2008-09-10 10:00:00	SPY	ETF	123.9	124.1	123.39	123.53	21659368.0
2008-09-10 10:30:00	SPY	ETF	123.53	123.86	122.84	122.99	28521551.0
2008-09-10 11:00:00	SPY	ETF	123.0	123.22	122.65	122.6812	17783589.0
2008-09-10 11:30:00	SPY	ETF	122.68	123.79	122.55	123.46	26117851.0
2008-09-10 12:00:00	SPY	ETF	123.46	123.94	123.35	123.54	16042820.0
2008-09-10 12:30:00	SPY	ETF	123.53	124.01	123.52	123.62	10878238.0
2008-09-10 13:00:00	SPY	ETF	123.62	123.73	123.4	123.6	8496197.0
2008-09-10 13:30:00	SPY	ETF	123.6	124.08	123.53	123.58	11485094.0
2008-09-10 14:00:00	SPY	ETF	123.58	124.59	123.52	124.39	23244599.0
2008-09-10 14:30:00	SPY	ETF	124.39	124.825	124.12	124.29	19186151.0
2008-09-10 15:00:00	SPY	ETF	124.29	124.9	124.23	124.39	17286026.0
2008-09-10 15:30:00	SPY	ETF	124.38	124.49	123.43	123.6	30988851.0
2008-09-10 16:00:00	SPY	ETF	123.6183	123.82	123.53	123.64	4518868.0
2008-09-10 16:30:00	SPY	ETF	123.64	123.87	123.64	123.84	1010786.0
2008-09-10 17:00:00	SPY	ETF	123.83	123.86	123.78	123.85	119173.0
2008-09-10 17:30:00	SPY	ETF	123.83	123.84	123.83	123.84	124980.0
2008-09-10 18:00:00	SPY	ETF	123.83	123.88	123.8	123.88	48881.0
2008-09-10 18:30:00	SPY	ETF	123.89	123.89	123.84	123.86	7700.0
2008-09-10 19:00:00	SPY	ETF	123.86	123.86	123.86	123.86	300.0
2008-09-10 19:30:00	SPY	ETF	123.83	123.83	123.54	123.54	28192.0
2008-09-10 04:00:00	QQQ	ETF	42.88	42.9	42.88	42.9	1500.0
2008-09-10 04:30:00	QQQ	ETF	42.9	43.0	42.9	43.0	2000.0
2008-09-10 05:00:00	QQQ	ETF	43.0	43.0	42.9	42.9	500.0
2008-09-10 05:30:00	QQQ	ETF	42.91	42.92	42.88	42.88	1900.0
2008-09-10 06:00:00	QQQ	ETF	42.85	42.95	42.85	42.93	2200.0
2008-09-10 06:30:00	QQQ	ETF	42.96	42.96	42.85	42.85	157900.0
2008-09-10 07:00:00	QQQ	ETF	42.86	42.94	42.8	42.86	325865.0
2008-09-10 07:30:00	QQQ	ETF	42.85	42.94	42.67	42.69	1629052.0
2008-09-10 08:00:00	QQQ	ETF	42.69	42.86	42.68	42.82	3474705.0
2008-09-10 08:30:00	QQQ	ETF	42.83	42.95	42.73	42.94	1780297.0
2008-09-10 09:00:00	QQQ	ETF	42.95	42.95	42.75	42.87	1200527.0
2008-09-10 09:30:00	QQQ	ETF	42.87	42.88	42.54	42.7	21679461.0
2008-09-10 10:00:00	QQQ	ETF	42.69	42.89	42.61	42.7	11504363.0
2008-09-10 10:30:00	QQQ	ETF	42.69	42.83	42.52	42.56	11946178.0
2008-09-10 11:00:00	QQQ	ETF	42.56	42.68	42.45	42.55	7823231.0
2008-09-10 11:30:00	QQQ	ETF	42.54	42.89	42.52	42.79	11849916.0
2008-09-10 12:00:00	QQQ	ETF	42.8	42.96	42.75	42.83	7340830.0
2008-09-10 12:30:00	QQQ	ETF	42.84	43.02	42.84	42.9	8248500.0
2008-09-10 13:00:00	QQQ	ETF	42.91	42.95	42.81	42.86	3650269.0

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

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