PREVIEW / etf_30min / 2010-04-27

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-04-27.parquet
  size:    270 KB
  rows:    8,886

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
2010-04-27 04:00:00	SPY	ETF	121.2	121.2	121.2	121.2	129.0
2010-04-27 04:30:00	SPY	ETF	121.24	121.3	121.24	121.25	2335.0
2010-04-27 05:00:00	SPY	ETF	121.27	121.3	121.2	121.2	3600.0
2010-04-27 05:30:00	SPY	ETF	121.15	121.15	121.02	121.02	13200.0
2010-04-27 06:00:00	SPY	ETF	121.01	121.01	120.92	120.94	9450.0
2010-04-27 06:30:00	SPY	ETF	120.85	120.85	120.7	120.75	114900.0
2010-04-27 07:00:00	SPY	ETF	120.79	120.91	120.76	120.8	365043.0
2010-04-27 07:30:00	SPY	ETF	120.8	120.96	120.78	120.78	300807.0
2010-04-27 08:00:00	SPY	ETF	120.8	120.91	120.74	120.77	463879.0
2010-04-27 08:30:00	SPY	ETF	120.77	120.84	120.71	120.79	1136735.0
2010-04-27 09:00:00	SPY	ETF	120.78	120.78	120.57	120.64	1790959.0
2010-04-27 09:30:00	SPY	ETF	120.65	120.99	120.61	120.86	27520993.0
2010-04-27 10:00:00	SPY	ETF	120.87	121.1	120.74	121.0401	16942355.0
2010-04-27 10:30:00	SPY	ETF	121.05	121.27	120.91	121.08	20724965.0
2010-04-27 11:00:00	SPY	ETF	121.09	121.13	119.55	119.6399	37226131.0
2010-04-27 11:30:00	SPY	ETF	119.62	119.7444	119.19	119.26	46430982.0
2010-04-27 12:00:00	SPY	ETF	119.27	119.5	118.84	119.11	26484800.0
2010-04-27 12:30:00	SPY	ETF	119.11	119.46	119.04	119.429	9990084.0
2010-04-27 13:00:00	SPY	ETF	119.42	119.94	119.4	119.94	19349463.0
2010-04-27 13:30:00	SPY	ETF	119.94	119.97	119.66	119.78	11046241.0
2010-04-27 14:00:00	SPY	ETF	119.78	119.805	119.41	119.49	15268813.0
2010-04-27 14:30:00	SPY	ETF	119.492	119.52	119.06	119.17	19194090.0
2010-04-27 15:00:00	SPY	ETF	119.17	119.57	119.09	119.289	19905408.0
2010-04-27 15:30:00	SPY	ETF	119.29	119.3	118.25	118.49	55165199.0
2010-04-27 16:00:00	SPY	ETF	118.47	121.3346	118.42	118.59	20244142.0
2010-04-27 16:30:00	SPY	ETF	118.6	118.66	118.44	118.61	1995426.0
2010-04-27 17:00:00	SPY	ETF	118.61	118.64	118.49	118.49	212989.0
2010-04-27 17:30:00	SPY	ETF	118.47	118.55	118.45	118.45	652183.0
2010-04-27 18:00:00	SPY	ETF	118.49	118.6	118.48	118.55	126644.0
2010-04-27 18:30:00	SPY	ETF	118.53	118.6	118.52	118.6	74691.0
2010-04-27 19:00:00	SPY	ETF	118.6	118.63	118.57	118.57	38421.0
2010-04-27 19:30:00	SPY	ETF	118.55	118.75	118.55	118.72	95541.0
2010-04-27 05:00:00	QQQ	ETF	50.37	50.37	50.37	50.37	500.0
2010-04-27 05:30:00	QQQ	ETF	50.34	50.34	50.32	50.32	5555.0
2010-04-27 06:00:00	QQQ	ETF	50.27	50.27	50.27	50.27	250.0
2010-04-27 06:30:00	QQQ	ETF	50.21	50.21	50.2	50.2	3333.0
2010-04-27 07:00:00	QQQ	ETF	50.24	50.3	50.24	50.27	29231.0
2010-04-27 07:30:00	QQQ	ETF	50.27	50.32	50.26	50.26	37393.0
2010-04-27 08:00:00	QQQ	ETF	50.26	50.3	50.23	50.24	170029.0
2010-04-27 08:30:00	QQQ	ETF	50.24	50.28	50.23	50.25	98320.0
2010-04-27 09:00:00	QQQ	ETF	50.25	50.25	50.18	50.21	183388.0
2010-04-27 09:30:00	QQQ	ETF	50.21	50.32	50.12	50.26	10061377.0
2010-04-27 10:00:00	QQQ	ETF	50.25	50.33	50.18	50.3	7280198.0
2010-04-27 10:30:00	QQQ	ETF	50.3	50.43	50.26	50.31	7663639.0
2010-04-27 11:00:00	QQQ	ETF	50.31	50.33	49.66	49.7	12254665.0
2010-04-27 11:30:00	QQQ	ETF	49.7	49.7	49.49	49.56	14576482.0
2010-04-27 12:00:00	QQQ	ETF	49.56	49.64	49.38	49.44	11120964.0
2010-04-27 12:30:00	QQQ	ETF	49.43	49.59	49.42	49.54	2743904.0
2010-04-27 13:00:00	QQQ	ETF	49.55	49.83	49.55	49.83	4623185.0
2010-04-27 13:30:00	QQQ	ETF	49.83	49.85	49.7	49.76	2516605.0

> showing 50 of 8,886 rows — these rows as CSV

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