PREVIEW / etf_30min / 2012-02-16

all etf 30-min files

  file:    by_date/etf_30min/2012/2012-02-16.parquet
  size:    295 KB
  rows:    9,680

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-02-16 04:00:00	SPY	ETF	134.13	134.22	134.09	134.1	5100.0
2012-02-16 05:00:00	SPY	ETF	134.12	134.13	134.12	134.13	1250.0
2012-02-16 05:30:00	SPY	ETF	134.08	134.29	134.06	134.29	31355.0
2012-02-16 06:00:00	SPY	ETF	134.28	134.33	134.25	134.25	13300.0
2012-02-16 06:30:00	SPY	ETF	134.25	134.25	134.15	134.23	47300.0
2012-02-16 07:00:00	SPY	ETF	134.22	134.32	134.13	134.15	200177.0
2012-02-16 07:30:00	SPY	ETF	134.12	134.12	133.95	134.05	165297.0
2012-02-16 08:00:00	SPY	ETF	134.05	134.28	133.99	134.28	663015.0
2012-02-16 08:30:00	SPY	ETF	134.29	134.63	134.28	134.43	2646377.0
2012-02-16 09:00:00	SPY	ETF	134.43	134.64	134.38	134.58	900550.0
2012-02-16 09:30:00	SPY	ETF	134.57	134.82	134.33	134.665	21681710.0
2012-02-16 10:00:00	SPY	ETF	134.67	135.09	134.61	135.05	17007168.0
2012-02-16 10:30:00	SPY	ETF	135.06	135.15	134.9	134.92	10192066.0
2012-02-16 11:00:00	SPY	ETF	134.92	135.2	134.87	135.16	10826243.0
2012-02-16 11:30:00	SPY	ETF	135.15	135.68	135.07	135.58	18348703.0
2012-02-16 12:00:00	SPY	ETF	135.585	135.81	135.55	135.67	12320399.0
2012-02-16 12:30:00	SPY	ETF	135.67	135.75	135.59	135.75	5779192.0
2012-02-16 13:00:00	SPY	ETF	135.74	135.99	135.71	135.89	9523947.0
2012-02-16 13:30:00	SPY	ETF	135.9	136.1	135.89	135.95	8133552.0
2012-02-16 14:00:00	SPY	ETF	135.95	136.02	135.88	135.97	5004648.0
2012-02-16 14:30:00	SPY	ETF	135.98	136.12	135.93	136.02	7547310.0
2012-02-16 15:00:00	SPY	ETF	136.02	136.08	135.85	135.99	7997590.0
2012-02-16 15:30:00	SPY	ETF	135.99	136.17	135.93	136.05	22149669.0
2012-02-16 16:00:00	SPY	ETF	136.04	136.09	134.5705	135.97	12648730.0
2012-02-16 16:30:00	SPY	ETF	135.95	136.04	135.4394	135.95	11639994.0
2012-02-16 17:00:00	SPY	ETF	135.96	136.01	135.95	136.01	220540.0
2012-02-16 17:30:00	SPY	ETF	136.0	136.04	136.0	136.03	35825.0
2012-02-16 18:00:00	SPY	ETF	136.01	136.05	135.99	135.99	214749.0
2012-02-16 18:30:00	SPY	ETF	136.0	136.0	135.95	135.95	24934.0
2012-02-16 19:00:00	SPY	ETF	135.97	136.02	135.97	135.99	76377.0
2012-02-16 19:30:00	SPY	ETF	135.99	136.03	135.97	136.03	65028.0
2012-02-16 04:00:00	QQQ	ETF	62.66	62.66	62.66	62.66	200.0
2012-02-16 05:00:00	QQQ	ETF	62.7	62.7	62.7	62.7	100.0
2012-02-16 06:00:00	QQQ	ETF	62.74	62.77	62.74	62.75	5800.0
2012-02-16 06:30:00	QQQ	ETF	62.76	62.76	62.69	62.71	5520.0
2012-02-16 07:00:00	QQQ	ETF	62.73	62.75	62.7	62.71	6490.0
2012-02-16 07:30:00	QQQ	ETF	62.65	62.67	62.62	62.64	65750.0
2012-02-16 08:00:00	QQQ	ETF	62.7	62.72	62.6	62.71	401896.0
2012-02-16 08:30:00	QQQ	ETF	62.73	62.87	62.68	62.76	1270113.0
2012-02-16 09:00:00	QQQ	ETF	62.76	62.86	62.75	62.79	1228070.0
2012-02-16 09:30:00	QQQ	ETF	62.79	62.86	62.63	62.79	9709468.0
2012-02-16 10:00:00	QQQ	ETF	62.79	62.98	62.7263	62.95	8240037.0
2012-02-16 10:30:00	QQQ	ETF	62.95	62.98	62.76	62.77	2712515.0
2012-02-16 11:00:00	QQQ	ETF	62.775	62.92	62.74	62.9	2816725.0
2012-02-16 11:30:00	QQQ	ETF	62.9	63.18	62.83	63.13	6398392.0
2012-02-16 12:00:00	QQQ	ETF	63.13	63.31	63.12	63.27	5484997.0
2012-02-16 12:30:00	QQQ	ETF	63.28	63.4	63.27	63.35	3505603.0
2012-02-16 13:00:00	QQQ	ETF	63.35	63.57	63.3302	63.499	3748255.0
2012-02-16 13:30:00	QQQ	ETF	63.5	63.67	63.49	63.62	2446638.0
2012-02-16 14:00:00	QQQ	ETF	63.63	63.65	63.54	63.64	2043086.0

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

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