PREVIEW / etf_30min / 2012-10-05

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-05.parquet
  size:    291 KB
  rows:    9,690

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
2012-10-05 04:00:00	SPY	ETF	146.25	146.25	146.06	146.06	750.0
2012-10-05 04:30:00	SPY	ETF	146.03	146.03	146.03	146.03	1000.0
2012-10-05 05:30:00	SPY	ETF	146.29	146.29	146.18	146.18	20401.0
2012-10-05 06:00:00	SPY	ETF	146.25	146.28	146.25	146.28	7600.0
2012-10-05 06:30:00	SPY	ETF	146.33	146.33	146.25	146.3	31400.0
2012-10-05 07:00:00	SPY	ETF	146.32	146.36	146.25	146.28	51302.0
2012-10-05 07:30:00	SPY	ETF	146.32	146.49	146.31	146.45	48690.0
2012-10-05 08:00:00	SPY	ETF	146.44	146.47	145.87	146.35	559745.0
2012-10-05 08:30:00	SPY	ETF	146.41	146.91	146.4	146.77	3427727.0
2012-10-05 09:00:00	SPY	ETF	146.78	146.97	146.27	146.91	1169053.0
2012-10-05 09:30:00	SPY	ETF	146.91	147.01	146.67	146.91	15634172.0
2012-10-05 10:00:00	SPY	ETF	146.91	147.16	146.74	147.07	8462294.0
2012-10-05 10:30:00	SPY	ETF	147.07	147.15	146.76	146.871	6746968.0
2012-10-05 11:00:00	SPY	ETF	146.871	146.895	146.7	146.715	4844112.0
2012-10-05 11:30:00	SPY	ETF	146.715	146.84	146.57	146.68	6156574.0
2012-10-05 12:00:00	SPY	ETF	146.69	146.76	146.52	146.669	6205486.0
2012-10-05 12:30:00	SPY	ETF	146.67	146.81	146.61	146.73	4297770.0
2012-10-05 13:00:00	SPY	ETF	146.72	146.76	146.51	146.51	3457238.0
2012-10-05 13:30:00	SPY	ETF	146.52	146.56	146.37	146.45	6712143.0
2012-10-05 14:00:00	SPY	ETF	146.4597	146.52	146.29	146.39	4056642.0
2012-10-05 14:30:00	SPY	ETF	146.39	146.39	145.93	145.9601	8164312.0
2012-10-05 15:00:00	SPY	ETF	145.965	146.13	145.82	146.06	10476795.0
2012-10-05 15:30:00	SPY	ETF	146.06	146.15	145.7	146.15	17916243.0
2012-10-05 16:00:00	SPY	ETF	146.15	146.797	146.0	146.06	7638399.0
2012-10-05 16:30:00	SPY	ETF	146.04	146.08	146.0	146.08	391349.0
2012-10-05 17:00:00	SPY	ETF	146.08	146.15	146.02	146.1	247796.0
2012-10-05 17:30:00	SPY	ETF	146.11	146.14	146.02	146.03	47584.0
2012-10-05 18:00:00	SPY	ETF	146.07	146.07	146.0	146.0	19622.0
2012-10-05 18:30:00	SPY	ETF	146.0	146.05	145.88	145.88	113298.0
2012-10-05 19:00:00	SPY	ETF	145.86	145.95	145.84	145.95	20212.0
2012-10-05 19:30:00	SPY	ETF	145.95	145.98	145.82	145.83	27305.0
2012-10-05 05:30:00	QQQ	ETF	69.46	69.46	69.45	69.45	600.0
2012-10-05 06:30:00	QQQ	ETF	69.49	69.49	69.49	69.49	1200.0
2012-10-05 07:00:00	QQQ	ETF	69.47	69.53	69.47	69.5	37600.0
2012-10-05 07:30:00	QQQ	ETF	69.51	69.55	69.5	69.54	6440.0
2012-10-05 08:00:00	QQQ	ETF	69.54	69.54	69.47	69.51	32565.0
2012-10-05 08:30:00	QQQ	ETF	69.59	69.76	69.51	69.68	307349.0
2012-10-05 09:00:00	QQQ	ETF	69.68	69.76	69.65	69.67	301764.0
2012-10-05 09:30:00	QQQ	ETF	69.68	69.77	69.54	69.68	3501131.0
2012-10-05 10:00:00	QQQ	ETF	69.68	69.8	69.58	69.75	1670920.0
2012-10-05 10:30:00	QQQ	ETF	69.76	69.79	69.47	69.49	2099759.0
2012-10-05 11:00:00	QQQ	ETF	69.5	69.53	69.41	69.44	1467351.0
2012-10-05 11:30:00	QQQ	ETF	69.44	69.47	69.29	69.33	1375014.0
2012-10-05 12:00:00	QQQ	ETF	69.33	69.34	69.16	69.27	1492411.0
2012-10-05 12:30:00	QQQ	ETF	69.28	69.38	69.28	69.36	963625.0
2012-10-05 13:00:00	QQQ	ETF	69.36	69.42	69.24	69.2401	785129.0
2012-10-05 13:30:00	QQQ	ETF	69.24	69.33	69.2	69.26	820642.0
2012-10-05 14:00:00	QQQ	ETF	69.26	69.305	69.14	69.2025	1264262.0
2012-10-05 14:30:00	QQQ	ETF	69.2	69.2159	68.95	68.96	1857809.0
2012-10-05 15:00:00	QQQ	ETF	68.97	69.05	68.88	68.99	2134312.0

> showing 50 of 9,690 rows — these rows as CSV

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