PREVIEW / etf_30min / 2012-07-12

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-07-12.parquet
  size:    282 KB
  rows:    9,418

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-07-12 04:00:00	SPY	ETF	133.18	133.89	133.18	133.78	136420.0
2012-07-12 04:30:00	SPY	ETF	133.67	133.78	133.43	133.46	162800.0
2012-07-12 05:00:00	SPY	ETF	133.46	133.56	133.46	133.56	17750.0
2012-07-12 05:30:00	SPY	ETF	133.49	133.66	133.47	133.51	47856.0
2012-07-12 06:00:00	SPY	ETF	133.55	133.55	133.28	133.28	19890.0
2012-07-12 06:30:00	SPY	ETF	133.29	133.29	133.0	133.14	108043.0
2012-07-12 07:00:00	SPY	ETF	133.12	133.24	133.03	133.17	135053.0
2012-07-12 07:30:00	SPY	ETF	133.21	133.28	133.07	133.22	249913.0
2012-07-12 08:00:00	SPY	ETF	133.26	133.81	133.05	133.34	793485.0
2012-07-12 08:30:00	SPY	ETF	133.4	133.56	133.05	133.29	1885713.0
2012-07-12 09:00:00	SPY	ETF	133.29	133.41	133.19	133.35	697313.0
2012-07-12 09:30:00	SPY	ETF	133.38	133.39	132.77	132.94	16245871.0
2012-07-12 10:00:00	SPY	ETF	132.94	133.02	132.67	132.86	9966335.0
2012-07-12 10:30:00	SPY	ETF	132.85	132.97	132.6	132.9	8459418.0
2012-07-12 11:00:00	SPY	ETF	132.9	133.18	132.84	133.1	7744084.0
2012-07-12 11:30:00	SPY	ETF	133.11	133.49	133.01	133.41	8309267.0
2012-07-12 12:00:00	SPY	ETF	133.401	133.48	133.26	133.33	4986530.0
2012-07-12 12:30:00	SPY	ETF	133.33	133.46	133.21	133.428	4454108.0
2012-07-12 13:00:00	SPY	ETF	133.42	133.89	133.33	133.65	10359684.0
2012-07-12 13:30:00	SPY	ETF	133.65	134.03	133.58	133.62	7632371.0
2012-07-12 14:00:00	SPY	ETF	133.63	133.91	133.48	133.73	11315321.0
2012-07-12 14:30:00	SPY	ETF	133.74	133.91	133.65	133.82	6131304.0
2012-07-12 15:00:00	SPY	ETF	133.81	134.1	133.7	133.91	11501898.0
2012-07-12 15:30:00	SPY	ETF	133.9005	134.07	133.5	133.59	21027999.0
2012-07-12 16:00:00	SPY	ETF	133.58	134.2269	133.1834	133.51	8116676.0
2012-07-12 16:30:00	SPY	ETF	133.52	133.66	133.52	133.66	311352.0
2012-07-12 17:00:00	SPY	ETF	133.63	133.64	133.57	133.64	135512.0
2012-07-12 17:30:00	SPY	ETF	133.63	133.63	133.56	133.6	25415.0
2012-07-12 18:00:00	SPY	ETF	133.61	133.75	133.61	133.71	85547.0
2012-07-12 18:30:00	SPY	ETF	133.72	133.75	133.71	133.75	10860.0
2012-07-12 19:00:00	SPY	ETF	133.71	133.73	133.61	133.66	11997.0
2012-07-12 19:30:00	SPY	ETF	133.61	133.63	133.48	133.52	46767.0
2012-07-12 04:00:00	QQQ	ETF	62.73	62.73	62.73	62.73	500.0
2012-07-12 04:30:00	QQQ	ETF	62.62	62.62	62.62	62.62	400.0
2012-07-12 05:30:00	QQQ	ETF	62.63	62.66	62.63	62.66	2000.0
2012-07-12 06:00:00	QQQ	ETF	62.66	62.66	62.66	62.66	400.0
2012-07-12 06:30:00	QQQ	ETF	62.55	62.58	62.49	62.5	11800.0
2012-07-12 07:00:00	QQQ	ETF	62.5	62.56	62.49	62.53	67535.0
2012-07-12 07:30:00	QQQ	ETF	62.53	62.62	62.49	62.58	237692.0
2012-07-12 08:00:00	QQQ	ETF	62.6	62.64	62.54	62.62	127488.0
2012-07-12 08:30:00	QQQ	ETF	62.7	62.7	62.48	62.51	393523.0
2012-07-12 09:00:00	QQQ	ETF	62.51	62.57	62.48	62.55	293484.0
2012-07-12 09:30:00	QQQ	ETF	62.55	62.57	62.1	62.17	6018606.0
2012-07-12 10:00:00	QQQ	ETF	62.16	62.21	61.96	62.04	4001096.0
2012-07-12 10:30:00	QQQ	ETF	62.03	62.08	61.86	62.05	2662472.0
2012-07-12 11:00:00	QQQ	ETF	62.05	62.21	62.02	62.15	2603155.0
2012-07-12 11:30:00	QQQ	ETF	62.16	62.4	62.11	62.35	3451508.0
2012-07-12 12:00:00	QQQ	ETF	62.359	62.385	62.23	62.28	2178890.0
2012-07-12 12:30:00	QQQ	ETF	62.27	62.335	62.2	62.3	1200820.0
2012-07-12 13:00:00	QQQ	ETF	62.3	62.655	62.28	62.5228	3972405.0

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

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