PREVIEW / etf_30min / 2010-05-13

all etf 30-min files

  file:    by_date/etf_30min/2010/2010-05-13.parquet
  size:    260 KB
  rows:    8,696

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-05-13 04:30:00	SPY	ETF	117.38	117.38	117.15	117.15	3134.0
2010-05-13 05:00:00	SPY	ETF	117.15	117.3	117.09	117.15	35600.0
2010-05-13 05:30:00	SPY	ETF	117.13	117.22	117.13	117.22	300.0
2010-05-13 06:00:00	SPY	ETF	117.23	117.46	117.23	117.46	8100.0
2010-05-13 06:30:00	SPY	ETF	117.39	117.45	117.31	117.45	13500.0
2010-05-13 07:00:00	SPY	ETF	117.41	117.61	117.36	117.57	294410.0
2010-05-13 07:30:00	SPY	ETF	117.56	117.71	117.54	117.55	308437.0
2010-05-13 08:00:00	SPY	ETF	117.56	117.79	116.96	117.71	1132890.0
2010-05-13 08:30:00	SPY	ETF	117.7	117.7	117.21	117.23	2340944.0
2010-05-13 09:00:00	SPY	ETF	117.22	117.45	117.04	117.13	3126226.0
2010-05-13 09:30:00	SPY	ETF	117.13	117.38	116.67	117.08	29557438.0
2010-05-13 10:00:00	SPY	ETF	117.08	117.56	116.94	117.38	17352856.0
2010-05-13 10:30:00	SPY	ETF	117.38	117.68	117.26	117.3	15238412.0
2010-05-13 11:00:00	SPY	ETF	117.3	117.44	117.05	117.3	13308730.0
2010-05-13 11:30:00	SPY	ETF	117.29	117.33	116.85	116.9	12967449.0
2010-05-13 12:00:00	SPY	ETF	116.9	117.3566	116.85	117.07	10332913.0
2010-05-13 12:30:00	SPY	ETF	117.08	117.23	117.02	117.06	6106075.0
2010-05-13 13:00:00	SPY	ETF	117.06	117.39	116.96	117.28	10021580.0
2010-05-13 13:30:00	SPY	ETF	117.29	117.45	117.1	117.23	9118049.0
2010-05-13 14:00:00	SPY	ETF	117.24	117.44	117.16	117.2	6125595.0
2010-05-13 14:30:00	SPY	ETF	117.2	117.29	116.74	116.85	11568911.0
2010-05-13 15:00:00	SPY	ETF	116.84	117.4	116.13	116.31	27597009.0
2010-05-13 15:30:00	SPY	ETF	116.31	116.58	115.89	116.0	42905008.0
2010-05-13 16:00:00	SPY	ETF	115.99	117.62	115.961	116.06	12414627.0
2010-05-13 16:30:00	SPY	ETF	116.05	116.15	116.01	116.04	1627895.0
2010-05-13 17:00:00	SPY	ETF	116.04	116.13	115.99	116.06	192816.0
2010-05-13 17:30:00	SPY	ETF	116.04	116.04	115.95	116.0	90140.0
2010-05-13 18:00:00	SPY	ETF	116.02	116.14	115.99	116.14	94238.0
2010-05-13 18:30:00	SPY	ETF	116.16	116.16	116.02	116.04	15100.0
2010-05-13 19:00:00	SPY	ETF	116.03	116.04	116.02	116.03	3761.0
2010-05-13 19:30:00	SPY	ETF	116.02	116.04	115.96	116.0	31639.0
2010-05-13 05:30:00	QQQ	ETF	48.42	48.43	48.42	48.43	300.0
2010-05-13 06:00:00	QQQ	ETF	48.52	48.52	48.52	48.52	300.0
2010-05-13 06:30:00	QQQ	ETF	48.52	48.52	48.45	48.45	4200.0
2010-05-13 07:00:00	QQQ	ETF	48.51	48.63	48.47	48.58	25800.0
2010-05-13 07:30:00	QQQ	ETF	48.59	48.65	48.58	48.58	46735.0
2010-05-13 08:00:00	QQQ	ETF	48.6	48.66	48.59	48.61	202177.0
2010-05-13 08:30:00	QQQ	ETF	48.6	48.62	48.43	48.43	867178.0
2010-05-13 09:00:00	QQQ	ETF	48.44	48.495	48.35	48.42	3676723.0
2010-05-13 09:30:00	QQQ	ETF	48.42	48.72	48.32	48.629	12687325.0
2010-05-13 10:00:00	QQQ	ETF	48.62	48.79	48.53	48.72	8654199.0
2010-05-13 10:30:00	QQQ	ETF	48.72	48.79	48.59	48.61	7031200.0
2010-05-13 11:00:00	QQQ	ETF	48.61	48.66	48.5	48.55	4484250.0
2010-05-13 11:30:00	QQQ	ETF	48.568	48.57	48.3	48.31	5774000.0
2010-05-13 12:00:00	QQQ	ETF	48.31	48.41	48.26	48.31	5023501.0
2010-05-13 12:30:00	QQQ	ETF	48.32	48.63	48.3	48.3338	2015014.0
2010-05-13 13:00:00	QQQ	ETF	48.34	48.51	48.29	48.45	4690923.0
2010-05-13 13:30:00	QQQ	ETF	48.45	48.52	48.27	48.37	5335600.0
2010-05-13 14:00:00	QQQ	ETF	48.37	48.49	48.37	48.3801	2567350.0
2010-05-13 14:30:00	QQQ	ETF	48.385	48.4273	48.2	48.24	5373746.0

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

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