PREVIEW / etf_30min / 2012-10-03

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-10-03.parquet
  size:    280 KB
  rows:    9,444

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-03 04:00:00	SPY	ETF	144.19	144.69	144.19	144.66	2036.0
2012-10-03 04:30:00	SPY	ETF	144.55	144.55	144.55	144.55	500.0
2012-10-03 05:00:00	SPY	ETF	144.63	144.82	144.61	144.82	500.0
2012-10-03 05:30:00	SPY	ETF	144.75	144.81	144.75	144.76	990.0
2012-10-03 06:00:00	SPY	ETF	144.74	144.8	144.7	144.7	6733.0
2012-10-03 06:30:00	SPY	ETF	144.71	144.71	144.57	144.57	6200.0
2012-10-03 07:00:00	SPY	ETF	144.62	144.68	144.55	144.68	432955.0
2012-10-03 07:30:00	SPY	ETF	144.68	144.73	144.64	144.67	52900.0
2012-10-03 08:00:00	SPY	ETF	144.68	144.96	144.625	144.88	1199038.0
2012-10-03 08:30:00	SPY	ETF	144.88	144.9	144.64	144.85	670230.0
2012-10-03 09:00:00	SPY	ETF	144.87	144.93	144.5	144.89	691705.0
2012-10-03 09:30:00	SPY	ETF	144.89	144.89	144.32	144.4299	11237100.0
2012-10-03 10:00:00	SPY	ETF	144.43	144.93	144.13	144.8787	14439824.0
2012-10-03 10:30:00	SPY	ETF	144.89	144.95	144.58	144.68	7890586.0
2012-10-03 11:00:00	SPY	ETF	144.67	145.22	144.65	145.121	10399770.0
2012-10-03 11:30:00	SPY	ETF	145.12	145.34	145.06	145.259	7741745.0
2012-10-03 12:00:00	SPY	ETF	145.259	145.36	145.18	145.35	3950389.0
2012-10-03 12:30:00	SPY	ETF	145.36	145.43	145.26	145.3	4190769.0
2012-10-03 13:00:00	SPY	ETF	145.3	145.32	145.2	145.28	2165581.0
2012-10-03 13:30:00	SPY	ETF	145.27	145.271	144.81	144.94	7454380.0
2012-10-03 14:00:00	SPY	ETF	144.93	145.05	144.74	144.81	6103842.0
2012-10-03 14:30:00	SPY	ETF	144.8	145.05	144.77	144.86	6128772.0
2012-10-03 15:00:00	SPY	ETF	144.859	145.1	144.68	145.04	8938721.0
2012-10-03 15:30:00	SPY	ETF	145.04	145.16	144.9	145.09	14102162.0
2012-10-03 16:00:00	SPY	ETF	145.09	145.11	144.5569	145.05	6257487.0
2012-10-03 16:30:00	SPY	ETF	145.03	145.15	144.98	145.09	404342.0
2012-10-03 17:00:00	SPY	ETF	145.1	145.26	145.07	145.25	612990.0
2012-10-03 17:30:00	SPY	ETF	145.24	145.24	145.18	145.18	19285.0
2012-10-03 18:00:00	SPY	ETF	145.19	145.32	145.19	145.32	140709.0
2012-10-03 18:30:00	SPY	ETF	145.31	145.47	145.31	145.38	49631.0
2012-10-03 19:00:00	SPY	ETF	145.39	145.39	145.33	145.34	34150.0
2012-10-03 19:30:00	SPY	ETF	145.33	145.36	145.24	145.31	48912.0
2012-10-03 04:30:00	QQQ	ETF	68.7	68.7	68.7	68.7	200.0
2012-10-03 05:00:00	QQQ	ETF	68.77	68.77	68.77	68.77	100.0
2012-10-03 05:30:00	QQQ	ETF	68.81	68.81	68.81	68.81	100.0
2012-10-03 06:00:00	QQQ	ETF	68.8	68.8	68.8	68.8	5000.0
2012-10-03 06:30:00	QQQ	ETF	68.73	68.75	68.73	68.75	25000.0
2012-10-03 07:00:00	QQQ	ETF	68.77	68.8	68.71	68.8	299313.0
2012-10-03 07:30:00	QQQ	ETF	68.8	68.82	68.8	68.82	212000.0
2012-10-03 08:00:00	QQQ	ETF	68.83	68.95	68.76	68.9	1332745.0
2012-10-03 08:30:00	QQQ	ETF	68.9	68.9	68.77	68.87	198130.0
2012-10-03 09:00:00	QQQ	ETF	68.88	68.9	68.84	68.87	87094.0
2012-10-03 09:30:00	QQQ	ETF	68.88	68.97	68.69	68.76	2935505.0
2012-10-03 10:00:00	QQQ	ETF	68.76	69.02	68.59	68.99	2923411.0
2012-10-03 10:30:00	QQQ	ETF	68.99	69.02	68.8	68.85	1910105.0
2012-10-03 11:00:00	QQQ	ETF	68.85	69.15	68.84	69.09	2961188.0
2012-10-03 11:30:00	QQQ	ETF	69.08	69.2	69.04	69.15	2754301.0
2012-10-03 12:00:00	QQQ	ETF	69.15	69.19	69.09	69.19	1483546.0
2012-10-03 12:30:00	QQQ	ETF	69.19	69.24	69.12	69.16	1919579.0
2012-10-03 13:00:00	QQQ	ETF	69.16	69.1683	69.08	69.15	1237722.0

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

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