PREVIEW / etf_30min / 2008-09-05

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-09-05.parquet
  size:    181 KB
  rows:    6,308

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-05 04:30:00	SPY	ETF	123.24	123.24	123.22	123.22	300.0
2008-09-05 05:00:00	SPY	ETF	123.26	123.4	123.25	123.4	3000.0
2008-09-05 05:30:00	SPY	ETF	123.49	123.52	123.35	123.42	2000.0
2008-09-05 06:00:00	SPY	ETF	123.41	123.47	123.34	123.34	141000.0
2008-09-05 06:30:00	SPY	ETF	123.37	123.42	123.33	123.4	49450.0
2008-09-05 07:00:00	SPY	ETF	123.37	123.61	123.3	123.53	526894.0
2008-09-05 07:30:00	SPY	ETF	123.53	123.85	123.53	123.82	646423.0
2008-09-05 08:00:00	SPY	ETF	123.83	123.85	123.4	123.6	2463744.0
2008-09-05 08:30:00	SPY	ETF	123.45	123.83	122.46	122.8	13120307.0
2008-09-05 09:00:00	SPY	ETF	122.8	123.37	122.78	123.29	3875855.0
2008-09-05 09:30:00	SPY	ETF	123.29	123.84	123.1	123.3	31183588.0
2008-09-05 10:00:00	SPY	ETF	123.305	123.57	122.0	122.75	28716055.0
2008-09-05 10:30:00	SPY	ETF	122.74	123.07	122.25	122.33	20109263.0
2008-09-05 11:00:00	SPY	ETF	122.33	122.79	122.11	122.751	22719096.0
2008-09-05 11:30:00	SPY	ETF	122.75	123.67	122.35	123.395	24091628.0
2008-09-05 12:00:00	SPY	ETF	123.39	123.64	123.09	123.64	15325643.0
2008-09-05 12:30:00	SPY	ETF	123.64	123.87	123.44	123.61	14701184.0
2008-09-05 13:00:00	SPY	ETF	123.61	124.09	123.46	123.78	14504618.0
2008-09-05 13:30:00	SPY	ETF	123.79	124.05	123.52	123.87	11877547.0
2008-09-05 14:00:00	SPY	ETF	123.86	124.26	123.54	124.19	11934391.0
2008-09-05 14:30:00	SPY	ETF	124.2	124.71	124.0	124.51	15765014.0
2008-09-05 15:00:00	SPY	ETF	124.5	124.51	124.07	124.3	16272588.0
2008-09-05 15:30:00	SPY	ETF	124.3	124.95	124.22	124.64	27512206.0
2008-09-05 16:00:00	SPY	ETF	124.7	125.19	124.39	125.1	5863868.0
2008-09-05 16:30:00	SPY	ETF	125.13	126.2	124.28	126.09	3197906.0
2008-09-05 17:00:00	SPY	ETF	126.11	126.17	125.75	125.95	1047464.0
2008-09-05 17:30:00	SPY	ETF	125.95	126.4	125.95	126.0	665129.0
2008-09-05 18:00:00	SPY	ETF	126.02	126.13	125.91	125.91	424493.0
2008-09-05 18:30:00	SPY	ETF	125.95	125.96	125.87	125.9	59083.0
2008-09-05 19:00:00	SPY	ETF	125.9	126.01	125.85	125.9	44469.0
2008-09-05 19:30:00	SPY	ETF	125.86	125.95	125.82	125.85	25813.0
2008-09-05 04:00:00	QQQ	ETF	43.63	43.63	43.63	43.63	300.0
2008-09-05 05:30:00	QQQ	ETF	43.53	43.53	43.52	43.52	3000.0
2008-09-05 06:00:00	QQQ	ETF	43.51	43.55	43.51	43.55	30000.0
2008-09-05 06:30:00	QQQ	ETF	43.5	43.5	43.5	43.5	300.0
2008-09-05 07:00:00	QQQ	ETF	43.5	43.57	43.5	43.52	226200.0
2008-09-05 07:30:00	QQQ	ETF	43.51	43.72	43.51	43.69	346534.0
2008-09-05 08:00:00	QQQ	ETF	43.69	43.7	43.4	43.5	2321003.0
2008-09-05 08:30:00	QQQ	ETF	43.48	43.57	43.03	43.14	6299876.0
2008-09-05 09:00:00	QQQ	ETF	43.13	43.37	43.13	43.29	3500140.0
2008-09-05 09:30:00	QQQ	ETF	43.3	43.55	43.25	43.47	37020322.0
2008-09-05 10:00:00	QQQ	ETF	43.47	43.6005	43.19	43.23	22532383.0
2008-09-05 10:30:00	QQQ	ETF	43.23	43.33	42.93	42.96	23946524.0
2008-09-05 11:00:00	QQQ	ETF	42.97	43.13	42.81	43.1	17359130.0
2008-09-05 11:30:00	QQQ	ETF	43.09	43.41	43.04	43.3	15457602.0
2008-09-05 12:00:00	QQQ	ETF	43.3	43.418	43.23	43.41	11870133.0
2008-09-05 12:30:00	QQQ	ETF	43.41	43.56	43.38	43.45	11004076.0
2008-09-05 13:00:00	QQQ	ETF	43.4499	43.72	43.4	43.46	11340319.0
2008-09-05 13:30:00	QQQ	ETF	43.45	43.57	43.32	43.5	7374000.0
2008-09-05 14:00:00	QQQ	ETF	43.5	43.62	43.32	43.5401	14345263.0

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

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