PREVIEW / etf_30min / 2009-04-23

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-04-23.parquet
  size:    213 KB
  rows:    7,095

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-23 04:00:00	SPY	ETF	84.94	85.02	84.89	85.02	6957.0
2009-04-23 04:30:00	SPY	ETF	84.95	84.95	84.87	84.89	1100.0
2009-04-23 05:00:00	SPY	ETF	84.87	85.14	84.85	85.14	9700.0
2009-04-23 05:30:00	SPY	ETF	85.11	85.2	85.02	85.02	9100.0
2009-04-23 06:00:00	SPY	ETF	85.09	85.09	85.05	85.05	200.0
2009-04-23 06:30:00	SPY	ETF	84.96	85.01	84.77	84.85	49700.0
2009-04-23 07:00:00	SPY	ETF	84.85	85.26	84.81	85.16	446575.0
2009-04-23 07:30:00	SPY	ETF	85.14	85.17	84.74	84.95	1192187.0
2009-04-23 08:00:00	SPY	ETF	85.04	85.18	84.85	85.15	1883798.0
2009-04-23 08:30:00	SPY	ETF	85.14	85.16	84.71	84.94	2582079.0
2009-04-23 09:00:00	SPY	ETF	84.95	85.0	84.57	84.72	2476031.0
2009-04-23 09:30:00	SPY	ETF	84.71	84.97	84.3	84.34	26300204.0
2009-04-23 10:00:00	SPY	ETF	84.34	84.6	83.83	84.54	28504056.0
2009-04-23 10:30:00	SPY	ETF	84.54	84.73	84.01	84.02	18345794.0
2009-04-23 11:00:00	SPY	ETF	84.02	84.2	83.63	83.84	21607789.0
2009-04-23 11:30:00	SPY	ETF	83.85	84.03	83.66	83.7701	14375874.0
2009-04-23 12:00:00	SPY	ETF	83.77	84.23	83.71	84.12	10477858.0
2009-04-23 12:30:00	SPY	ETF	84.13	84.34	83.92	84.28	11128698.0
2009-04-23 13:00:00	SPY	ETF	84.29	84.85	84.28	84.7005	15972742.0
2009-04-23 13:30:00	SPY	ETF	84.7025	84.85	84.48	84.69	16046627.0
2009-04-23 14:00:00	SPY	ETF	84.7	84.71	84.34	84.66	13905624.0
2009-04-23 14:30:00	SPY	ETF	84.65	85.14	84.63	84.73	28002123.0
2009-04-23 15:00:00	SPY	ETF	84.74	84.81	84.15	84.5	27716315.0
2009-04-23 15:30:00	SPY	ETF	84.49	85.42	84.24	85.36	52042094.0
2009-04-23 16:00:00	SPY	ETF	85.33	85.55	83.9127	85.53	13986740.0
2009-04-23 16:30:00	SPY	ETF	85.43	85.8	84.74	85.48	4778782.0
2009-04-23 17:00:00	SPY	ETF	85.46	85.63	85.46	85.48	354969.0
2009-04-23 17:30:00	SPY	ETF	85.47	85.65	85.47	85.59	4082546.0
2009-04-23 18:00:00	SPY	ETF	85.52	85.6	85.46	85.58	187910.0
2009-04-23 18:30:00	SPY	ETF	85.61	85.63	85.47	85.5	57155.0
2009-04-23 19:00:00	SPY	ETF	85.47	85.5	85.47	85.48	4640.0
2009-04-23 19:30:00	SPY	ETF	85.48	85.48	85.36	85.38	66250.0
2009-04-23 04:00:00	QQQ	ETF	32.92	32.98	32.92	32.98	200.0
2009-04-23 04:30:00	QQQ	ETF	33.0	33.0	33.0	33.0	200.0
2009-04-23 05:00:00	QQQ	ETF	33.0	33.04	33.0	33.04	300.0
2009-04-23 05:30:00	QQQ	ETF	33.09	33.11	33.09	33.11	10200.0
2009-04-23 06:00:00	QQQ	ETF	33.07	33.07	33.07	33.07	1200.0
2009-04-23 06:30:00	QQQ	ETF	33.05	33.05	33.01	33.03	700.0
2009-04-23 07:00:00	QQQ	ETF	33.0	33.15	33.0	33.12	253871.0
2009-04-23 07:30:00	QQQ	ETF	33.11	33.12	33.02	33.1	538959.0
2009-04-23 08:00:00	QQQ	ETF	33.1	33.15	33.0528	33.15	1059347.0
2009-04-23 08:30:00	QQQ	ETF	33.14	33.19	33.02	33.15	1014693.0
2009-04-23 09:00:00	QQQ	ETF	33.15	33.16	32.99	33.01	1117264.0
2009-04-23 09:30:00	QQQ	ETF	33.01	33.08	32.76	32.8001	20785856.0
2009-04-23 10:00:00	QQQ	ETF	32.8	33.0299	32.65	32.98	15286123.0
2009-04-23 10:30:00	QQQ	ETF	32.98	33.05	32.66	32.69	13188267.0
2009-04-23 11:00:00	QQQ	ETF	32.68	32.74	32.49	32.61	10024973.0
2009-04-23 11:30:00	QQQ	ETF	32.62	32.68	32.52	32.57	6433474.0
2009-04-23 12:00:00	QQQ	ETF	32.56	32.84	32.56	32.7131	10264198.0
2009-04-23 12:30:00	QQQ	ETF	32.71	32.88	32.65	32.83	5485009.0

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

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