PREVIEW / etf_30min / 2012-09-04

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-09-04.parquet
  size:    286 KB
  rows:    9,637

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-09-04 04:00:00	SPY	ETF	141.3	141.35	141.3	141.35	300.0
2012-09-04 04:30:00	SPY	ETF	141.35	141.35	141.3	141.3	300.0
2012-09-04 06:00:00	SPY	ETF	141.37	141.37	141.26	141.26	46965.0
2012-09-04 06:30:00	SPY	ETF	141.25	141.25	140.92	140.92	47235.0
2012-09-04 07:00:00	SPY	ETF	140.99	141.08	140.93	141.05	63930.0
2012-09-04 07:30:00	SPY	ETF	141.05	141.22	141.01	141.19	79390.0
2012-09-04 08:00:00	SPY	ETF	141.18	141.22	141.02	141.04	464738.0
2012-09-04 08:30:00	SPY	ETF	141.04	141.15	141.03	141.04	146322.0
2012-09-04 09:00:00	SPY	ETF	141.03	141.24	140.95	141.05	722447.0
2012-09-04 09:30:00	SPY	ETF	141.04	141.17	140.85	140.97	10240994.0
2012-09-04 10:00:00	SPY	ETF	140.97	141.04	140.39	140.43	11912207.0
2012-09-04 10:30:00	SPY	ETF	140.431	140.54	140.13	140.27	11917766.0
2012-09-04 11:00:00	SPY	ETF	140.26	140.47	140.19	140.44	5801505.0
2012-09-04 11:30:00	SPY	ETF	140.44	140.5	140.32	140.4313	4512957.0
2012-09-04 12:00:00	SPY	ETF	140.44	140.47	140.31	140.35	3201860.0
2012-09-04 12:30:00	SPY	ETF	140.36	140.52	140.32	140.49	2837790.0
2012-09-04 13:00:00	SPY	ETF	140.49	140.61	140.47	140.6	2697745.0
2012-09-04 13:30:00	SPY	ETF	140.609	140.65	140.45	140.53	3071167.0
2012-09-04 14:00:00	SPY	ETF	140.53	140.96	140.48	140.94	10477483.0
2012-09-04 14:30:00	SPY	ETF	140.95	141.46	140.94	141.24	11338005.0
2012-09-04 15:00:00	SPY	ETF	141.25	141.36	141.2	141.34	6719782.0
2012-09-04 15:30:00	SPY	ETF	141.33	141.37	140.95	140.95	16696748.0
2012-09-04 16:00:00	SPY	ETF	140.95	141.29	140.7457	141.21	9697966.0
2012-09-04 16:30:00	SPY	ETF	141.22	141.26	141.05	141.09	3836402.0
2012-09-04 17:00:00	SPY	ETF	141.06	141.51	141.05	141.06	398626.0
2012-09-04 17:30:00	SPY	ETF	141.06	141.06	140.97	141.0	199388.0
2012-09-04 18:00:00	SPY	ETF	141.02	141.18	141.0	141.17	503819.0
2012-09-04 18:30:00	SPY	ETF	141.1	141.16	141.05	141.09	66600.0
2012-09-04 19:00:00	SPY	ETF	141.09	141.1	141.03	141.07	23699.0
2012-09-04 19:30:00	SPY	ETF	141.05	141.08	141.0	141.03	77936.0
2012-09-04 04:00:00	QQQ	ETF	68.27	68.33	68.27	68.33	600.0
2012-09-04 06:30:00	QQQ	ETF	68.2	68.2	68.07	68.07	1000.0
2012-09-04 07:00:00	QQQ	ETF	68.07	68.1	68.05	68.1	300.0
2012-09-04 07:30:00	QQQ	ETF	68.06	68.15	68.06	68.15	14395.0
2012-09-04 08:00:00	QQQ	ETF	68.15	68.16	68.04	68.05	37725.0
2012-09-04 08:30:00	QQQ	ETF	68.05	68.1	68.04	68.05	36348.0
2012-09-04 09:00:00	QQQ	ETF	68.0	68.11	68.0	68.06	78159.0
2012-09-04 09:30:00	QQQ	ETF	68.03	68.14	67.87	68.05	2362181.0
2012-09-04 10:00:00	QQQ	ETF	68.05	68.11	67.73	67.75	2810203.0
2012-09-04 10:30:00	QQQ	ETF	67.75	67.75	67.42	67.5	4221491.0
2012-09-04 11:00:00	QQQ	ETF	67.5	67.6	67.44	67.6	3294987.0
2012-09-04 11:30:00	QQQ	ETF	67.6	67.7	67.54	67.67	1989281.0
2012-09-04 12:00:00	QQQ	ETF	67.67	67.69	67.59	67.63	582991.0
2012-09-04 12:30:00	QQQ	ETF	67.63	67.76	67.609	67.76	746631.0
2012-09-04 13:00:00	QQQ	ETF	67.75	67.85	67.74	67.8301	1328118.0
2012-09-04 13:30:00	QQQ	ETF	67.84	67.87	67.7617	67.81	707836.0
2012-09-04 14:00:00	QQQ	ETF	67.811	68.1	67.795	68.09	1644889.0
2012-09-04 14:30:00	QQQ	ETF	68.09	68.35	68.09	68.24	2598984.0
2012-09-04 15:00:00	QQQ	ETF	68.24	68.29	68.18	68.28	1810708.0
2012-09-04 15:30:00	QQQ	ETF	68.28	68.29	68.09	68.1	4237614.0

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

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