PREVIEW / etf_30min / 2008-11-05

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-05.parquet
  size:    184 KB
  rows:    6,420

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-11-05 04:00:00	SPY	ETF	98.64	98.81	98.56	98.71	5326.0
2008-11-05 04:30:00	SPY	ETF	99.0	99.02	98.66	98.66	600.0
2008-11-05 05:00:00	SPY	ETF	98.77	98.9	98.41	98.7	30900.0
2008-11-05 05:30:00	SPY	ETF	98.75	99.02	98.67	98.88	9000.0
2008-11-05 06:00:00	SPY	ETF	99.04	99.55	98.99	99.42	9600.0
2008-11-05 06:30:00	SPY	ETF	99.24	99.84	99.24	99.75	193000.0
2008-11-05 07:00:00	SPY	ETF	99.68	99.83	99.41	99.69	452525.0
2008-11-05 07:30:00	SPY	ETF	99.7	99.7	98.97	99.35	812483.0
2008-11-05 08:00:00	SPY	ETF	99.35	100.5	98.738	98.97	3296799.0
2008-11-05 08:30:00	SPY	ETF	98.98	99.38	98.97	99.32	1636902.0
2008-11-05 09:00:00	SPY	ETF	99.32	99.4	98.71	99.1	1572511.0
2008-11-05 09:30:00	SPY	ETF	99.2	99.39	98.55	98.97	41795859.0
2008-11-05 10:00:00	SPY	ETF	98.97	100.0	98.78	99.96	34152205.0
2008-11-05 10:30:00	SPY	ETF	99.96	100.2	99.44	99.5001	24800968.0
2008-11-05 11:00:00	SPY	ETF	99.51	99.75	99.08	99.18	17469881.0
2008-11-05 11:30:00	SPY	ETF	99.1605	99.17	98.44	98.87	25540086.0
2008-11-05 12:00:00	SPY	ETF	98.87	98.96	97.77	97.85	23076143.0
2008-11-05 12:30:00	SPY	ETF	97.84	100.41	97.14	97.66	21778180.0
2008-11-05 13:00:00	SPY	ETF	97.66	97.95	97.39	97.65	13742062.0
2008-11-05 13:30:00	SPY	ETF	97.65	97.79	97.09	97.36	18792495.0
2008-11-05 14:00:00	SPY	ETF	97.35	97.64	96.87	97.2	18954877.0
2008-11-05 14:30:00	SPY	ETF	97.2	97.91	97.13	97.37	24345616.0
2008-11-05 15:00:00	SPY	ETF	97.36	100.7113	96.29	96.53	28770788.0
2008-11-05 15:30:00	SPY	ETF	96.53	100.7114	95.0	95.44	65817343.0
2008-11-05 16:00:00	SPY	ETF	95.5	100.7114	95.4	95.91	13597925.0
2008-11-05 16:30:00	SPY	ETF	95.98	100.7114	94.89	94.97	5805804.0
2008-11-05 17:00:00	SPY	ETF	94.99	95.04	94.75	95.0	488619.0
2008-11-05 17:30:00	SPY	ETF	95.0	95.01	94.8	94.8	124140.0
2008-11-05 18:00:00	SPY	ETF	94.85	100.711	94.63	94.82	2223595.0
2008-11-05 18:30:00	SPY	ETF	94.85	95.05	94.8	95.04	152776.0
2008-11-05 19:00:00	SPY	ETF	95.0	95.05	94.8	94.8	47186.0
2008-11-05 19:30:00	SPY	ETF	94.81	94.96	94.76	94.78	53362.0
2008-11-05 04:00:00	QQQ	ETF	33.42	33.46	33.41	33.43	4500.0
2008-11-05 04:30:00	QQQ	ETF	33.48	33.48	33.43	33.43	2300.0
2008-11-05 05:30:00	QQQ	ETF	33.42	33.42	33.42	33.42	500.0
2008-11-05 06:00:00	QQQ	ETF	33.53	33.6	33.53	33.59	2100.0
2008-11-05 06:30:00	QQQ	ETF	33.56	33.75	33.52	33.75	3900.0
2008-11-05 07:00:00	QQQ	ETF	33.68	33.74	33.58	33.63	50730.0
2008-11-05 07:30:00	QQQ	ETF	33.62	33.62	33.48	33.52	202145.0
2008-11-05 08:00:00	QQQ	ETF	33.51	33.56	33.33	33.38	929127.0
2008-11-05 08:30:00	QQQ	ETF	33.38	33.48	33.38	33.47	724489.0
2008-11-05 09:00:00	QQQ	ETF	33.47	33.6	33.41	33.48	477772.0
2008-11-05 09:30:00	QQQ	ETF	33.48	33.55	33.28	33.3401	20136768.0
2008-11-05 10:00:00	QQQ	ETF	33.35	33.54	33.29	33.4999	15715414.0
2008-11-05 10:30:00	QQQ	ETF	33.5	33.6	33.33	33.348	10726039.0
2008-11-05 11:00:00	QQQ	ETF	33.36	33.45	33.21	33.26	8180454.0
2008-11-05 11:30:00	QQQ	ETF	33.26	33.5	33.05	33.14	12183714.0
2008-11-05 12:00:00	QQQ	ETF	33.15	33.1801	32.72	32.75	11442540.0
2008-11-05 12:30:00	QQQ	ETF	32.76	32.84	32.53	32.8	11025363.0
2008-11-05 13:00:00	QQQ	ETF	32.81	32.84	32.63	32.73	5766905.0

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

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