PREVIEW / etf_30min / 2012-11-07

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-11-07.parquet
  size:    312 KB
  rows:    10,500

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-11-07 04:00:00	SPY	ETF	143.36	143.44	143.28	143.28	31224.0
2012-11-07 04:30:00	SPY	ETF	143.28	143.48	143.28	143.48	18700.0
2012-11-07 05:00:00	SPY	ETF	143.45	143.61	143.45	143.5	9354.0
2012-11-07 05:30:00	SPY	ETF	143.55	143.63	143.43	143.45	7000.0
2012-11-07 06:00:00	SPY	ETF	143.35	143.4	143.07	143.07	62408.0
2012-11-07 06:30:00	SPY	ETF	143.16	143.2	143.04	143.08	139006.0
2012-11-07 07:00:00	SPY	ETF	143.04	143.04	142.05	142.26	1056578.0
2012-11-07 07:30:00	SPY	ETF	142.23	142.42	142.1	142.21	1120629.0
2012-11-07 08:00:00	SPY	ETF	142.2	142.21	141.8	142.0	1086095.0
2012-11-07 08:30:00	SPY	ETF	141.99	142.14	141.82	141.88	1982409.0
2012-11-07 09:00:00	SPY	ETF	141.87	141.96	141.64	141.67	2153600.0
2012-11-07 09:30:00	SPY	ETF	141.66	141.68	140.82	141.09	25140023.0
2012-11-07 10:00:00	SPY	ETF	141.09	141.1	140.29	140.52	21415023.0
2012-11-07 10:30:00	SPY	ETF	140.52	140.71	139.72	139.76	19591071.0
2012-11-07 11:00:00	SPY	ETF	139.76	140.14	139.35	139.43	19966788.0
2012-11-07 11:30:00	SPY	ETF	139.44	139.89	139.06	139.87	24586129.0
2012-11-07 12:00:00	SPY	ETF	139.87	140.06	139.6228	139.92	19934747.0
2012-11-07 12:30:00	SPY	ETF	139.91	140.14	139.89	139.98	11816758.0
2012-11-07 13:00:00	SPY	ETF	139.98	140.5	139.92	140.21	15218371.0
2012-11-07 13:30:00	SPY	ETF	140.21	140.48	140.17	140.205	6754497.0
2012-11-07 14:00:00	SPY	ETF	140.24	140.53	140.2	140.335	6178334.0
2012-11-07 14:30:00	SPY	ETF	140.34	140.34	139.93	140.31	14649951.0
2012-11-07 15:00:00	SPY	ETF	140.3	140.59	140.01	140.53	12473893.0
2012-11-07 15:30:00	SPY	ETF	140.54	140.59	139.7	139.72	29509061.0
2012-11-07 16:00:00	SPY	ETF	139.73	143.1152	139.45	139.65	14394268.0
2012-11-07 16:30:00	SPY	ETF	139.66	139.88	139.65	139.78	3625698.0
2012-11-07 17:00:00	SPY	ETF	139.77	139.9	139.63	139.88	1328394.0
2012-11-07 17:30:00	SPY	ETF	139.88	139.93	139.86	139.91	2057710.0
2012-11-07 18:00:00	SPY	ETF	139.91	140.08	139.91	139.98	120971.0
2012-11-07 18:30:00	SPY	ETF	140.01	140.81	139.99	140.0	1682812.0
2012-11-07 19:00:00	SPY	ETF	139.97	139.97	139.84	139.85	31530.0
2012-11-07 19:30:00	SPY	ETF	139.88	140.04	139.85	140.04	42888.0
2012-11-07 04:00:00	QQQ	ETF	65.86	65.87	65.86	65.87	369.0
2012-11-07 04:30:00	QQQ	ETF	65.93	65.93	65.93	65.93	100.0
2012-11-07 05:30:00	QQQ	ETF	66.01	66.01	66.01	66.01	1100.0
2012-11-07 06:30:00	QQQ	ETF	65.8	65.8	65.76	65.76	300.0
2012-11-07 07:00:00	QQQ	ETF	65.76	65.76	65.3	65.35	26178.0
2012-11-07 07:30:00	QQQ	ETF	65.35	65.44	65.25	65.26	40615.0
2012-11-07 08:00:00	QQQ	ETF	65.28	65.97	65.12	65.21	427152.0
2012-11-07 08:30:00	QQQ	ETF	65.17	65.25	65.1	65.13	378424.0
2012-11-07 09:00:00	QQQ	ETF	65.12	65.16	65.02	65.02	255294.0
2012-11-07 09:30:00	QQQ	ETF	65.04	65.1	64.8	64.97	7723555.0
2012-11-07 10:00:00	QQQ	ETF	64.97	64.98	64.49	64.61	4565597.0
2012-11-07 10:30:00	QQQ	ETF	64.61	64.66	64.17	64.18	3976569.0
2012-11-07 11:00:00	QQQ	ETF	64.1817	64.39	64.06	64.09	4491167.0
2012-11-07 11:30:00	QQQ	ETF	64.09	64.39	63.9	64.26	5021100.0
2012-11-07 12:00:00	QQQ	ETF	64.2801	64.37	64.19	64.28	2130726.0
2012-11-07 12:30:00	QQQ	ETF	64.27	64.32	64.11	64.1599	2316630.0
2012-11-07 13:00:00	QQQ	ETF	64.16	64.43	64.11	64.36	4154966.0
2012-11-07 13:30:00	QQQ	ETF	64.36	64.52	64.295	64.32	2607363.0

> showing 50 of 10,500 rows — these rows as CSV

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