PREVIEW / etf_30min / 2012-06-22

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-06-22.parquet
  size:    271 KB
  rows:    9,218

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-06-22 04:00:00	SPY	ETF	132.31	132.83	132.31	132.83	300.0
2012-06-22 04:30:00	SPY	ETF	132.83	132.94	132.83	132.94	1100.0
2012-06-22 05:00:00	SPY	ETF	132.94	132.94	132.9	132.91	8600.0
2012-06-22 05:30:00	SPY	ETF	132.91	132.98	132.82	132.98	65559.0
2012-06-22 06:00:00	SPY	ETF	132.95	133.03	132.9	132.96	57310.0
2012-06-22 06:30:00	SPY	ETF	133.04	133.05	132.99	133.02	13490.0
2012-06-22 07:00:00	SPY	ETF	132.99	133.05	132.54	132.55	224547.0
2012-06-22 07:30:00	SPY	ETF	132.53	132.83	132.41	132.78	168689.0
2012-06-22 08:00:00	SPY	ETF	132.76	133.01	132.68	132.89	608796.0
2012-06-22 08:30:00	SPY	ETF	132.89	132.91	132.76	132.86	543332.0
2012-06-22 09:00:00	SPY	ETF	132.86	133.22	132.86	133.12	2607358.0
2012-06-22 09:30:00	SPY	ETF	133.13	133.22	132.79	133.02	18264761.0
2012-06-22 10:00:00	SPY	ETF	133.02	133.3	132.82	132.83	16512954.0
2012-06-22 10:30:00	SPY	ETF	132.825	132.95	132.62	132.88	8685016.0
2012-06-22 11:00:00	SPY	ETF	132.88	133.0962	132.8	132.81	7967756.0
2012-06-22 11:30:00	SPY	ETF	132.81	133.119	132.8	133.03	6965384.0
2012-06-22 12:00:00	SPY	ETF	133.03	133.07	132.81	132.91	5927508.0
2012-06-22 12:30:00	SPY	ETF	132.91	133.01	132.83	132.91	4340218.0
2012-06-22 13:00:00	SPY	ETF	132.91	133.02	132.81	132.98	4167485.0
2012-06-22 13:30:00	SPY	ETF	132.98	133.15	132.96	133.12	4094078.0
2012-06-22 14:00:00	SPY	ETF	133.1199	133.26	133.09	133.19	4977637.0
2012-06-22 14:30:00	SPY	ETF	133.19	133.52	133.145	133.51	6201250.0
2012-06-22 15:00:00	SPY	ETF	133.51	133.6	133.31	133.355	6425505.0
2012-06-22 15:30:00	SPY	ETF	133.36	133.71	133.29	133.46	18844325.0
2012-06-22 16:00:00	SPY	ETF	133.46	133.65	132.8313	133.1	8181017.0
2012-06-22 16:30:00	SPY	ETF	133.1	133.14	133.0	133.05	2699919.0
2012-06-22 17:00:00	SPY	ETF	133.05	133.09	133.01	133.05	221126.0
2012-06-22 17:30:00	SPY	ETF	133.05	133.09	133.04	133.05	46454.0
2012-06-22 18:00:00	SPY	ETF	133.05	133.11	133.04	133.11	88642.0
2012-06-22 18:30:00	SPY	ETF	133.11	133.11	133.03	133.07	38020.0
2012-06-22 19:00:00	SPY	ETF	133.07	133.13	133.07	133.1	15039.0
2012-06-22 19:30:00	SPY	ETF	133.08	133.17	133.06	133.12	39035.0
2012-06-22 06:00:00	QQQ	ETF	63.0	63.0	63.0	63.0	200.0
2012-06-22 06:30:00	QQQ	ETF	63.0	63.0	63.0	63.0	100.0
2012-06-22 07:00:00	QQQ	ETF	62.93	62.95	62.7	62.7	18100.0
2012-06-22 07:30:00	QQQ	ETF	62.65	62.82	62.65	62.79	4100.0
2012-06-22 08:00:00	QQQ	ETF	62.79	62.85	62.7	62.83	72590.0
2012-06-22 08:30:00	QQQ	ETF	62.83	62.85	62.78	62.85	68960.0
2012-06-22 09:00:00	QQQ	ETF	62.85	62.96	62.85	62.88	218749.0
2012-06-22 09:30:00	QQQ	ETF	62.89	62.99	62.731	62.91	3991422.0
2012-06-22 10:00:00	QQQ	ETF	62.91	63.1	62.89	62.89	3339656.0
2012-06-22 10:30:00	QQQ	ETF	62.89	62.95	62.75	62.89	2513085.0
2012-06-22 11:00:00	QQQ	ETF	62.89	63.03	62.88	62.92	2543303.0
2012-06-22 11:30:00	QQQ	ETF	62.91	63.05	62.91	63.0	1243330.0
2012-06-22 12:00:00	QQQ	ETF	63.0	63.03	62.91	62.95	1669507.0
2012-06-22 12:30:00	QQQ	ETF	62.9499	63.06	62.93	63.025	1214578.0
2012-06-22 13:00:00	QQQ	ETF	63.02	63.06	62.97	63.0099	626854.0
2012-06-22 13:30:00	QQQ	ETF	63.0001	63.09	62.9999	63.07	673696.0
2012-06-22 14:00:00	QQQ	ETF	63.08	63.17	63.08	63.12	1149969.0
2012-06-22 14:30:00	QQQ	ETF	63.12	63.28	63.0999	63.2701	1453623.0

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

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