PREVIEW / etf_30min / 2014-09-15

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-15.parquet
  size:    341 KB
  rows:    11,559

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
2014-09-15 04:00:00	SPY	ETF	198.52	198.72	198.52	198.72	775.0
2014-09-15 04:30:00	SPY	ETF	198.72	198.76	198.65	198.65	14287.0
2014-09-15 05:00:00	SPY	ETF	198.74	198.74	198.65	198.65	2885.0
2014-09-15 05:30:00	SPY	ETF	198.6	198.69	198.57	198.69	7223.0
2014-09-15 06:00:00	SPY	ETF	198.67	198.8	198.67	198.79	17411.0
2014-09-15 06:30:00	SPY	ETF	198.77	198.77	198.7	198.73	54841.0
2014-09-15 07:00:00	SPY	ETF	198.77	199.07	198.75	199.03	126723.0
2014-09-15 07:30:00	SPY	ETF	199.02	199.02	198.85	198.86	150351.0
2014-09-15 08:00:00	SPY	ETF	198.88	199.01	198.48	198.94	138428.0
2014-09-15 08:30:00	SPY	ETF	198.97	199.09	198.85	199.06	419611.0
2014-09-15 09:00:00	SPY	ETF	199.06	199.21	199.06	199.15	583109.0
2014-09-15 09:30:00	SPY	ETF	199.16	199.19	198.44	198.615	11106246.0
2014-09-15 10:00:00	SPY	ETF	198.61	199.03	198.38	198.98	6973008.0
2014-09-15 10:30:00	SPY	ETF	198.98	199.08	198.63	198.9	4448796.0
2014-09-15 11:00:00	SPY	ETF	198.9	198.967	198.54	198.6	3967638.0
2014-09-15 11:30:00	SPY	ETF	198.59	198.77	198.52	198.55	4485102.0
2014-09-15 12:00:00	SPY	ETF	198.5534	198.87	198.47	198.74	3831959.0
2014-09-15 12:30:00	SPY	ETF	198.75	199.07	198.645	198.93	3855097.0
2014-09-15 13:00:00	SPY	ETF	198.92	199.04	198.77	198.78	3613930.0
2014-09-15 13:30:00	SPY	ETF	198.79	198.97	198.6	198.635	2647810.0
2014-09-15 14:00:00	SPY	ETF	198.64	199.12	198.59	199.1	3115787.0
2014-09-15 14:30:00	SPY	ETF	199.11	199.32	199.0	199.03	6412707.0
2014-09-15 15:00:00	SPY	ETF	199.03	199.175	198.94	199.04	4180037.0
2014-09-15 15:30:00	SPY	ETF	199.05	199.125	198.9	198.99	7967083.0
2014-09-15 16:00:00	SPY	ETF	199.01	199.06	198.97	199.01	3966495.0
2014-09-15 16:30:00	SPY	ETF	199.01	199.06	198.9781	199.04	2088699.0
2014-09-15 17:00:00	SPY	ETF	199.05	199.07	199.05	199.07	39653.0
2014-09-15 17:30:00	SPY	ETF	199.05	199.05	199.05	199.05	9190.0
2014-09-15 18:00:00	SPY	ETF	199.03	199.03	198.98	198.98	13839.0
2014-09-15 18:30:00	SPY	ETF	199.01	199.01	198.97	199.0	9128.0
2014-09-15 19:00:00	SPY	ETF	199.02	199.02	199.02	199.02	830.0
2014-09-15 19:30:00	SPY	ETF	198.99	199.01	198.98	198.99	18335.0
2014-09-15 04:00:00	QQQ	ETF	99.22	99.35	99.22	99.29	6637.0
2014-09-15 05:30:00	QQQ	ETF	99.27	99.27	99.27	99.27	500.0
2014-09-15 06:30:00	QQQ	ETF	99.32	99.34	99.31	99.34	3000.0
2014-09-15 07:00:00	QQQ	ETF	99.4	99.5	99.4	99.49	14100.0
2014-09-15 07:30:00	QQQ	ETF	99.48	99.48	99.4	99.4	11900.0
2014-09-15 08:00:00	QQQ	ETF	99.41	99.47	99.41	99.41	18800.0
2014-09-15 08:30:00	QQQ	ETF	99.45	99.56	99.42	99.52	148648.0
2014-09-15 09:00:00	QQQ	ETF	99.52	99.63	99.52	99.59	277644.0
2014-09-15 09:30:00	QQQ	ETF	99.59	99.6	98.6	98.721	6111531.0
2014-09-15 10:00:00	QQQ	ETF	98.721	98.846	98.57	98.73	2495727.0
2014-09-15 10:30:00	QQQ	ETF	98.73	98.8227	98.5	98.62	2628945.0
2014-09-15 11:00:00	QQQ	ETF	98.61	98.66	98.41	98.4999	2774911.0
2014-09-15 11:30:00	QQQ	ETF	98.5	98.55	98.38	98.42	1434220.0
2014-09-15 12:00:00	QQQ	ETF	98.43	98.58	98.38	98.5399	1355786.0
2014-09-15 12:30:00	QQQ	ETF	98.54	98.63	98.48	98.62	1144814.0
2014-09-15 13:00:00	QQQ	ETF	98.62	98.659	98.36	98.36	1266665.0
2014-09-15 13:30:00	QQQ	ETF	98.37	98.49	98.24	98.265	1399063.0
2014-09-15 14:00:00	QQQ	ETF	98.26	98.53	98.215	98.51	1582332.0

> showing 50 of 11,559 rows — these rows as CSV

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