PREVIEW / etf_30min / 2012-05-17

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-05-17.parquet
  size:    308 KB
  rows:    10,300

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-05-17 04:00:00	SPY	ETF	133.06	133.1	133.06	133.1	350.0
2012-05-17 04:30:00	SPY	ETF	133.15	133.49	133.15	133.44	20400.0
2012-05-17 05:00:00	SPY	ETF	133.3	133.3	133.09	133.09	700.0
2012-05-17 05:30:00	SPY	ETF	133.15	133.15	133.15	133.15	300.0
2012-05-17 06:00:00	SPY	ETF	133.04	133.04	132.87	132.93	26782.0
2012-05-17 06:30:00	SPY	ETF	132.9	132.95	132.8	132.9	62490.0
2012-05-17 07:00:00	SPY	ETF	132.86	132.93	132.59	132.7	594350.0
2012-05-17 07:30:00	SPY	ETF	132.73	132.73	132.16	132.41	1254142.0
2012-05-17 08:00:00	SPY	ETF	132.43	133.1	132.21	132.61	708127.0
2012-05-17 08:30:00	SPY	ETF	132.6	133.01	132.39	133.0	1408011.0
2012-05-17 09:00:00	SPY	ETF	133.0	133.07	132.83	132.87	1081359.0
2012-05-17 09:30:00	SPY	ETF	132.86	133.02	132.29	132.54	23063964.0
2012-05-17 10:00:00	SPY	ETF	132.54	132.75	131.83	132.57	30823805.0
2012-05-17 10:30:00	SPY	ETF	132.57	132.74	132.23	132.488	14970465.0
2012-05-17 11:00:00	SPY	ETF	132.489	132.66	132.15	132.22	13446616.0
2012-05-17 11:30:00	SPY	ETF	132.22	132.235	131.86	132.0614	14562020.0
2012-05-17 12:00:00	SPY	ETF	132.07	132.09	131.44	131.82	19254596.0
2012-05-17 12:30:00	SPY	ETF	131.83	132.01	131.66	131.83	10579449.0
2012-05-17 13:00:00	SPY	ETF	131.84	132.29	131.82	132.13	11951842.0
2012-05-17 13:30:00	SPY	ETF	132.13	132.14	131.73	131.93	8956693.0
2012-05-17 14:00:00	SPY	ETF	131.93	131.93	131.63	131.73	10207192.0
2012-05-17 14:30:00	SPY	ETF	131.73	131.79	131.52	131.665	10857527.0
2012-05-17 15:00:00	SPY	ETF	131.66	131.8	131.41	131.52	13324803.0
2012-05-17 15:30:00	SPY	ETF	131.52	131.53	130.81	130.83	30510211.0
2012-05-17 16:00:00	SPY	ETF	130.83	132.8417	130.64	130.8	14827585.0
2012-05-17 16:30:00	SPY	ETF	130.78	132.8416	130.58	130.85	12563911.0
2012-05-17 17:00:00	SPY	ETF	130.87	131.03	130.79	131.01	165326.0
2012-05-17 17:30:00	SPY	ETF	131.01	131.01	130.86	130.94	229514.0
2012-05-17 18:00:00	SPY	ETF	130.94	131.05	130.78	130.9	99093.0
2012-05-17 18:30:00	SPY	ETF	130.89	130.89	130.73	130.88	42551.0
2012-05-17 19:00:00	SPY	ETF	130.87	130.88	130.81	130.85	12930.0
2012-05-17 19:30:00	SPY	ETF	130.86	131.03	130.84	131.0	174296.0
2012-05-17 04:00:00	QQQ	ETF	63.0	63.0	63.0	63.0	454.0
2012-05-17 04:30:00	QQQ	ETF	62.93	63.0	62.93	63.0	454.0
2012-05-17 06:00:00	QQQ	ETF	62.85	62.85	62.85	62.85	200.0
2012-05-17 06:30:00	QQQ	ETF	62.8	62.8	62.77	62.79	2100.0
2012-05-17 07:00:00	QQQ	ETF	62.78	62.84	62.7	62.7	4900.0
2012-05-17 07:30:00	QQQ	ETF	62.72	62.72	62.5	62.61	30500.0
2012-05-17 08:00:00	QQQ	ETF	62.63	62.74	62.62	62.7	230600.0
2012-05-17 08:30:00	QQQ	ETF	62.71	62.93	62.65	62.91	261793.0
2012-05-17 09:00:00	QQQ	ETF	62.92	62.98	62.81	62.95	434729.0
2012-05-17 09:30:00	QQQ	ETF	62.95	63.06	62.58	62.74	6523428.0
2012-05-17 10:00:00	QQQ	ETF	62.74	62.8601	62.44	62.81	8628246.0
2012-05-17 10:30:00	QQQ	ETF	62.8	62.82	62.51	62.6077	4161441.0
2012-05-17 11:00:00	QQQ	ETF	62.61	62.65	62.38	62.41	4638368.0
2012-05-17 11:30:00	QQQ	ETF	62.41	62.4299	62.24	62.3	3725657.0
2012-05-17 12:00:00	QQQ	ETF	62.31	62.31	62.05	62.23	4501561.0
2012-05-17 12:30:00	QQQ	ETF	62.22	62.34	62.14	62.26	2325670.0
2012-05-17 13:00:00	QQQ	ETF	62.27	62.55	62.26	62.441	3148417.0
2012-05-17 13:30:00	QQQ	ETF	62.45	62.46	62.21	62.3	2227905.0

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

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