PREVIEW / etf_30min / 2009-03-27

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-03-27.parquet
  size:    211 KB
  rows:    7,019

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
2009-03-27 04:00:00	SPY	ETF	82.64	82.64	82.64	82.64	100.0
2009-03-27 04:30:00	SPY	ETF	82.77	82.82	82.7	82.82	600.0
2009-03-27 05:00:00	SPY	ETF	82.8	82.89	82.66	82.66	4377.0
2009-03-27 05:30:00	SPY	ETF	82.66	82.66	82.51	82.51	4210.0
2009-03-27 06:00:00	SPY	ETF	82.62	82.62	82.33	82.36	36351.0
2009-03-27 06:30:00	SPY	ETF	82.32	82.45	82.32	82.35	124022.0
2009-03-27 07:00:00	SPY	ETF	82.4	82.61	82.36	82.55	160410.0
2009-03-27 07:30:00	SPY	ETF	82.6	82.67	82.22	82.22	567857.0
2009-03-27 08:00:00	SPY	ETF	82.23	83.11	81.96	82.12	3042205.0
2009-03-27 08:30:00	SPY	ETF	82.12	82.42	82.01	82.19	1083167.0
2009-03-27 09:00:00	SPY	ETF	82.2	82.7	81.85	82.04	2944192.0
2009-03-27 09:30:00	SPY	ETF	82.05	82.25	81.7	81.98	30553893.0
2009-03-27 10:00:00	SPY	ETF	81.99	82.1	81.5	81.95	22375892.0
2009-03-27 10:30:00	SPY	ETF	81.96	82.31	81.72	82.13	19208183.0
2009-03-27 11:00:00	SPY	ETF	82.13	82.5	81.96	82.23	21462309.0
2009-03-27 11:30:00	SPY	ETF	82.23	82.49	82.1	82.269	16011466.0
2009-03-27 12:00:00	SPY	ETF	82.25	82.53	82.02	82.04	21582845.0
2009-03-27 12:30:00	SPY	ETF	82.03	82.29	81.8	81.86	16257504.0
2009-03-27 13:00:00	SPY	ETF	81.85	81.93	81.63	81.88	13306637.0
2009-03-27 13:30:00	SPY	ETF	81.88	82.23	81.31	81.51	28164371.0
2009-03-27 14:00:00	SPY	ETF	81.51	82.05	81.32	81.84	20583145.0
2009-03-27 14:30:00	SPY	ETF	81.84	82.0	81.48	81.99	20513057.0
2009-03-27 15:00:00	SPY	ETF	81.99	82.37	81.73	81.8	26823624.0
2009-03-27 15:30:00	SPY	ETF	81.8	82.0	81.35	81.62	40197586.0
2009-03-27 16:00:00	SPY	ETF	81.6	83.11	81.58	82.05	9143818.0
2009-03-27 16:30:00	SPY	ETF	82.05	83.2806	81.99	82.12	2235316.0
2009-03-27 17:00:00	SPY	ETF	82.13	83.2806	82.01	82.12	2604325.0
2009-03-27 17:30:00	SPY	ETF	82.12	83.2806	82.02	82.07	2550677.0
2009-03-27 18:00:00	SPY	ETF	82.08	82.1	82.04	82.06	48625.0
2009-03-27 18:30:00	SPY	ETF	82.05	82.11	82.03	82.04	14732.0
2009-03-27 19:00:00	SPY	ETF	82.05	82.08	82.02	82.04	8515.0
2009-03-27 19:30:00	SPY	ETF	82.02	82.06	81.99	82.02	23075.0
2009-03-27 04:00:00	QQQ	ETF	31.23	31.23	31.2	31.2	400.0
2009-03-27 04:30:00	QQQ	ETF	31.19	31.19	31.19	31.19	1657.0
2009-03-27 05:30:00	QQQ	ETF	31.13	31.13	31.11	31.11	400.0
2009-03-27 06:00:00	QQQ	ETF	31.14	31.14	31.09	31.09	897.0
2009-03-27 06:30:00	QQQ	ETF	31.08	31.11	31.06	31.06	2900.0
2009-03-27 07:00:00	QQQ	ETF	31.1	31.18	31.08	31.18	50280.0
2009-03-27 07:30:00	QQQ	ETF	31.16	31.19	30.99	30.99	420106.0
2009-03-27 08:00:00	QQQ	ETF	30.99	31.04	30.93	30.96	1033385.0
2009-03-27 08:30:00	QQQ	ETF	30.96	31.12	30.9	30.94	1756424.0
2009-03-27 09:00:00	QQQ	ETF	30.94	31.15	30.89	31.07	974738.0
2009-03-27 09:30:00	QQQ	ETF	31.07	31.1	30.89	30.99	17132439.0
2009-03-27 10:00:00	QQQ	ETF	30.999	31.04	30.84	30.97	11582635.0
2009-03-27 10:30:00	QQQ	ETF	30.98	31.12	30.89	31.05	6669976.0
2009-03-27 11:00:00	QQQ	ETF	31.06	31.13	30.91	31.048	7833909.0
2009-03-27 11:30:00	QQQ	ETF	31.0499	31.18	30.99	31.098	8178202.0
2009-03-27 12:00:00	QQQ	ETF	31.09	31.18	30.94	30.98	8704156.0
2009-03-27 12:30:00	QQQ	ETF	30.97	31.08	30.87	30.89	8387545.0
2009-03-27 13:00:00	QQQ	ETF	30.88	30.89	30.73	30.86	16582334.0

> showing 50 of 7,019 rows — these rows as CSV

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