PREVIEW / etf_30min / 2012-12-03

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-12-03.parquet
  size:    293 KB
  rows:    9,931

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-12-03 04:00:00	SPY	ETF	142.33	142.33	142.33	142.33	150.0
2012-12-03 04:30:00	SPY	ETF	142.11	142.16	142.1	142.16	4900.0
2012-12-03 05:00:00	SPY	ETF	142.11	142.22	142.11	142.22	6500.0
2012-12-03 05:30:00	SPY	ETF	142.25	142.41	142.25	142.38	6900.0
2012-12-03 06:00:00	SPY	ETF	142.37	142.37	142.37	142.37	180.0
2012-12-03 06:30:00	SPY	ETF	142.39	142.54	142.38	142.51	143981.0
2012-12-03 07:00:00	SPY	ETF	142.53	142.7	142.5	142.6	439317.0
2012-12-03 07:30:00	SPY	ETF	142.6	143.02	142.55	142.69	947257.0
2012-12-03 08:00:00	SPY	ETF	142.72	142.85	142.64	142.76	410709.0
2012-12-03 08:30:00	SPY	ETF	142.75	142.82	142.06	142.79	531260.0
2012-12-03 09:00:00	SPY	ETF	142.8	142.85	142.68	142.79	805570.0
2012-12-03 09:30:00	SPY	ETF	142.8	142.92	142.52	142.58	14054836.0
2012-12-03 10:00:00	SPY	ETF	142.59	142.6	142.15	142.36	13936692.0
2012-12-03 10:30:00	SPY	ETF	142.37	142.39	141.95	142.04	8730557.0
2012-12-03 11:00:00	SPY	ETF	142.0499	142.13	141.92	142.025	6042926.0
2012-12-03 11:30:00	SPY	ETF	142.02	142.3	141.9	142.28	6589890.0
2012-12-03 12:00:00	SPY	ETF	142.285	142.3	142.13	142.23	3074470.0
2012-12-03 12:30:00	SPY	ETF	142.23	142.27	142.03	142.05	3898721.0
2012-12-03 13:00:00	SPY	ETF	142.04	142.04	141.84	141.92	4155620.0
2012-12-03 13:30:00	SPY	ETF	141.92	141.93	141.56	141.73	6043177.0
2012-12-03 14:00:00	SPY	ETF	141.72	141.91	141.66	141.74	5302475.0
2012-12-03 14:30:00	SPY	ETF	141.74	141.8	141.57	141.6999	5908907.0
2012-12-03 15:00:00	SPY	ETF	141.7	141.96	141.34	141.54	11973918.0
2012-12-03 15:30:00	SPY	ETF	141.53	141.79	141.38	141.46	13899749.0
2012-12-03 16:00:00	SPY	ETF	141.46	142.1698	141.33	141.35	9542082.0
2012-12-03 16:30:00	SPY	ETF	141.33	141.45	141.19	141.27	1515147.0
2012-12-03 17:00:00	SPY	ETF	141.26	142.1368	141.16	141.2	1112072.0
2012-12-03 17:30:00	SPY	ETF	141.23	141.26	141.23	141.25	11049.0
2012-12-03 18:00:00	SPY	ETF	141.28	141.31	141.27	141.29	25565.0
2012-12-03 18:30:00	SPY	ETF	141.25	141.35	141.25	141.33	15030.0
2012-12-03 19:00:00	SPY	ETF	141.3	141.3	141.13	141.16	49310.0
2012-12-03 19:30:00	SPY	ETF	141.16	141.16	141.04	141.11	189531.0
2012-12-03 04:00:00	QQQ	ETF	66.03	66.04	66.03	66.04	300.0
2012-12-03 05:00:00	QQQ	ETF	66.02	66.02	66.02	66.02	4000.0
2012-12-03 05:30:00	QQQ	ETF	66.0	66.09	66.0	66.09	200.0
2012-12-03 06:00:00	QQQ	ETF	66.07	66.07	66.07	66.07	6000.0
2012-12-03 06:30:00	QQQ	ETF	66.08	66.13	66.08	66.13	7744.0
2012-12-03 07:00:00	QQQ	ETF	66.14	66.19	66.14	66.18	14600.0
2012-12-03 07:30:00	QQQ	ETF	66.16	66.36	66.16	66.22	63573.0
2012-12-03 08:00:00	QQQ	ETF	66.23	66.28	65.94	66.25	65007.0
2012-12-03 08:30:00	QQQ	ETF	66.225	66.28	66.225	66.27	72741.0
2012-12-03 09:00:00	QQQ	ETF	66.27	66.33	66.24	66.32	402154.0
2012-12-03 09:30:00	QQQ	ETF	66.32	66.37	66.19	66.2801	3951750.0
2012-12-03 10:00:00	QQQ	ETF	66.26	66.281	66.07	66.19	3994906.0
2012-12-03 10:30:00	QQQ	ETF	66.182	66.205	65.92	65.98	1914793.0
2012-12-03 11:00:00	QQQ	ETF	65.99	66.02	65.91	65.96	1301249.0
2012-12-03 11:30:00	QQQ	ETF	65.95	66.09	65.89	66.09	1254114.0
2012-12-03 12:00:00	QQQ	ETF	66.0801	66.1	65.99	66.03	813704.0
2012-12-03 12:30:00	QQQ	ETF	66.03	66.05	65.91	65.91	1205693.0
2012-12-03 13:00:00	QQQ	ETF	65.91	65.93	65.83	65.9	1286939.0

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

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