PREVIEW / etf_30min / 2009-04-17

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-17.parquet
  size:    214 KB
  rows:    7,127

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-04-17 04:00:00	SPY	ETF	86.1	86.18	86.1	86.18	1100.0
2009-04-17 05:00:00	SPY	ETF	86.05	86.07	85.98	86.07	1600.0
2009-04-17 05:30:00	SPY	ETF	86.09	86.53	86.08	86.42	18501.0
2009-04-17 06:00:00	SPY	ETF	86.29	86.78	86.29	86.66	138369.0
2009-04-17 06:30:00	SPY	ETF	86.7	86.84	86.49	86.75	123650.0
2009-04-17 07:00:00	SPY	ETF	86.8	87.05	86.51	86.64	286484.0
2009-04-17 07:30:00	SPY	ETF	86.67	86.9	86.56	86.88	399408.0
2009-04-17 08:00:00	SPY	ETF	86.87	86.96	85.9	86.94	1354462.0
2009-04-17 08:30:00	SPY	ETF	86.93	86.93	86.15	86.39	2055101.0
2009-04-17 09:00:00	SPY	ETF	86.4	86.95	86.37	86.85	3728350.0
2009-04-17 09:30:00	SPY	ETF	86.83	87.1	86.31	86.58	34257875.0
2009-04-17 10:00:00	SPY	ETF	86.59	86.88	86.47	86.54	15895264.0
2009-04-17 10:30:00	SPY	ETF	86.54	86.55	86.14	86.39	14369580.0
2009-04-17 11:00:00	SPY	ETF	86.38	86.57	86.21	86.52	12547509.0
2009-04-17 11:30:00	SPY	ETF	86.53	86.9	86.45	86.74	12114709.0
2009-04-17 12:00:00	SPY	ETF	86.74	86.9	86.61	86.8899	8729615.0
2009-04-17 12:30:00	SPY	ETF	86.88	86.96	86.56	86.93	11242246.0
2009-04-17 13:00:00	SPY	ETF	86.93	87.24	86.88	87.17	12346826.0
2009-04-17 13:30:00	SPY	ETF	87.18	87.46	87.06	87.38	11783632.0
2009-04-17 14:00:00	SPY	ETF	87.38	87.44	87.17	87.36	10472228.0
2009-04-17 14:30:00	SPY	ETF	87.3501	87.63	87.05	87.12	17596502.0
2009-04-17 15:00:00	SPY	ETF	87.11	87.58	87.1	87.47	17307832.0
2009-04-17 15:30:00	SPY	ETF	87.47	87.65	86.95	87.13	43833492.0
2009-04-17 16:00:00	SPY	ETF	87.09	87.45	86.99	87.12	12093275.0
2009-04-17 16:30:00	SPY	ETF	87.13	87.17	86.6185	87.1	3337760.0
2009-04-17 17:00:00	SPY	ETF	87.1	87.12	87.08	87.08	2116580.0
2009-04-17 17:30:00	SPY	ETF	87.1	87.2	87.08	87.17	153636.0
2009-04-17 18:00:00	SPY	ETF	87.16	87.19	86.6185	87.17	4009117.0
2009-04-17 18:30:00	SPY	ETF	87.15	87.2	87.13	87.17	10218.0
2009-04-17 19:00:00	SPY	ETF	87.14	87.16	87.12	87.15	12467.0
2009-04-17 19:30:00	SPY	ETF	87.16	87.25	87.11	87.25	35777.0
2009-04-17 04:00:00	QQQ	ETF	32.96	32.96	32.96	32.96	200.0
2009-04-17 04:30:00	QQQ	ETF	32.97	32.97	32.97	32.97	225.0
2009-04-17 05:30:00	QQQ	ETF	32.99	32.99	32.99	32.99	2000.0
2009-04-17 06:00:00	QQQ	ETF	33.08	33.19	33.08	33.16	8100.0
2009-04-17 06:30:00	QQQ	ETF	33.18	33.2	33.04	33.16	23200.0
2009-04-17 07:00:00	QQQ	ETF	33.18	33.24	33.07	33.12	145122.0
2009-04-17 07:30:00	QQQ	ETF	33.11	33.24	33.11	33.24	185311.0
2009-04-17 08:00:00	QQQ	ETF	33.24	33.27	33.21	33.25	224075.0
2009-04-17 08:30:00	QQQ	ETF	33.24	33.25	32.97	33.05	243414.0
2009-04-17 09:00:00	QQQ	ETF	33.05	33.17	33.03	33.16	853421.0
2009-04-17 09:30:00	QQQ	ETF	33.16	33.2	32.95	33.1199	24785511.0
2009-04-17 10:00:00	QQQ	ETF	33.1199	33.22	33.05	33.07	10008337.0
2009-04-17 10:30:00	QQQ	ETF	33.07	33.08	32.93	32.97	7440814.0
2009-04-17 11:00:00	QQQ	ETF	32.97	33.06	32.93	33.035	4675471.0
2009-04-17 11:30:00	QQQ	ETF	33.03	33.12	32.99	33.07	4435521.0
2009-04-17 12:00:00	QQQ	ETF	33.08	33.14	33.05	33.13	2898959.0
2009-04-17 12:30:00	QQQ	ETF	33.13	33.19	32.99	33.18	6214782.0
2009-04-17 13:00:00	QQQ	ETF	33.18	33.27	33.17	33.238	4774053.0
2009-04-17 13:30:00	QQQ	ETF	33.2301	33.41	33.18	33.4	14585993.0

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

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