PREVIEW / etf_30min / 2008-11-19

all etf 30-min files

  file:    by_date/etf_30min/2008/2008-11-19.parquet
  size:    182 KB
  rows:    6,428

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-19 04:00:00	SPY	ETF	85.52	86.28	85.32	86.24	1600.0
2008-11-19 04:30:00	SPY	ETF	85.25	85.25	85.25	85.25	100.0
2008-11-19 05:00:00	SPY	ETF	85.66	85.66	85.66	85.66	600.0
2008-11-19 05:30:00	SPY	ETF	86.31	86.31	85.62	86.25	300.0
2008-11-19 06:00:00	SPY	ETF	85.99	86.02	85.81	85.81	8100.0
2008-11-19 06:30:00	SPY	ETF	85.67	86.0	85.63	86.0	33600.0
2008-11-19 07:00:00	SPY	ETF	86.01	86.24	85.69	85.73	995068.0
2008-11-19 07:30:00	SPY	ETF	85.75	86.0	85.43	85.43	1625107.0
2008-11-19 08:00:00	SPY	ETF	85.43	87.08	85.21	85.61	2595016.0
2008-11-19 08:30:00	SPY	ETF	85.7	85.98	84.93	85.16	4066444.0
2008-11-19 09:00:00	SPY	ETF	85.17	86.07	85.09	85.92	4643054.0
2008-11-19 09:30:00	SPY	ETF	85.91	86.78	85.25	85.59	46939018.0
2008-11-19 10:00:00	SPY	ETF	85.6	86.87	85.45	86.15	34688468.0
2008-11-19 10:30:00	SPY	ETF	86.15	86.36	84.29	84.38	30482390.0
2008-11-19 11:00:00	SPY	ETF	84.37	84.84	83.68	83.76	24367417.0
2008-11-19 11:30:00	SPY	ETF	83.76	84.15	83.26	83.82	34258613.0
2008-11-19 12:00:00	SPY	ETF	83.83	83.96	83.03	83.19	28636243.0
2008-11-19 12:30:00	SPY	ETF	83.19	83.91	83.08	83.77	21147193.0
2008-11-19 13:00:00	SPY	ETF	83.79	84.31	83.12	83.15	28037456.0
2008-11-19 13:30:00	SPY	ETF	83.15	84.01	82.69	83.67	28244649.0
2008-11-19 14:00:00	SPY	ETF	83.67	83.68	82.68	82.94	35240507.0
2008-11-19 14:30:00	SPY	ETF	82.93	86.2427	82.38	83.8	48861629.0
2008-11-19 15:00:00	SPY	ETF	83.8	84.11	82.25	82.74	65187202.0
2008-11-19 15:30:00	SPY	ETF	82.74	83.09	80.92	81.13	88886110.0
2008-11-19 16:00:00	SPY	ETF	81.22	83.7372	80.92	81.48	19134570.0
2008-11-19 16:30:00	SPY	ETF	81.48	84.78	81.3	81.31	5469111.0
2008-11-19 17:00:00	SPY	ETF	81.31	81.56	81.3	81.54	590643.0
2008-11-19 17:30:00	SPY	ETF	81.58	81.68	81.49	81.49	263724.0
2008-11-19 18:00:00	SPY	ETF	81.55	81.74	81.54	81.55	124488.0
2008-11-19 18:30:00	SPY	ETF	81.5	81.7	81.23	81.7	240824.0
2008-11-19 19:00:00	SPY	ETF	81.71	81.82	81.2	81.2	112473.0
2008-11-19 19:30:00	SPY	ETF	81.22	81.64	81.21	81.55	79173.0
2008-11-19 04:00:00	QQQ	ETF	28.3	28.3	28.19	28.3	2650.0
2008-11-19 04:30:00	QQQ	ETF	28.33	28.37	28.33	28.37	300.0
2008-11-19 05:30:00	QQQ	ETF	28.41	28.5	28.41	28.5	300.0
2008-11-19 06:00:00	QQQ	ETF	28.49	28.49	28.44	28.44	15200.0
2008-11-19 06:30:00	QQQ	ETF	28.38	28.38	28.35	28.37	12800.0
2008-11-19 07:00:00	QQQ	ETF	28.39	28.53	28.34	28.35	321517.0
2008-11-19 07:30:00	QQQ	ETF	28.35	28.46	28.31	28.32	410738.0
2008-11-19 08:00:00	QQQ	ETF	28.3	28.45	28.27	28.38	1656400.0
2008-11-19 08:30:00	QQQ	ETF	28.39	28.48	28.15	28.24	1187264.0
2008-11-19 09:00:00	QQQ	ETF	28.24	28.47	28.22	28.41	1501547.0
2008-11-19 09:30:00	QQQ	ETF	28.4	28.64	28.31	28.43	25235626.0
2008-11-19 10:00:00	QQQ	ETF	28.43	28.78	28.38	28.59	19420770.0
2008-11-19 10:30:00	QQQ	ETF	28.58	28.6	28.02	28.07	17857126.0
2008-11-19 11:00:00	QQQ	ETF	28.06	28.23	27.84	27.87	10998183.0
2008-11-19 11:30:00	QQQ	ETF	27.87	27.94	27.58	27.7	14142243.0
2008-11-19 12:00:00	QQQ	ETF	27.69	27.78	27.5	27.55	10368029.0
2008-11-19 12:30:00	QQQ	ETF	27.55	27.72	27.5	27.65	9859920.0
2008-11-19 13:00:00	QQQ	ETF	27.65	27.82	27.46	27.47	7035766.0

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

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