PREVIEW / etf_30min / 2014-09-16

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-09-16.parquet
  size:    351 KB
  rows:    11,722

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-16 04:00:00	SPY	ETF	198.8	198.84	198.79	198.79	2400.0
2014-09-16 04:30:00	SPY	ETF	198.79	198.8	198.74	198.74	400.0
2014-09-16 05:00:00	SPY	ETF	198.82	198.83	198.82	198.82	8037.0
2014-09-16 05:30:00	SPY	ETF	198.82	198.91	198.82	198.91	7701.0
2014-09-16 06:00:00	SPY	ETF	198.91	198.91	198.63	198.66	24712.0
2014-09-16 06:30:00	SPY	ETF	198.68	198.77	198.68	198.69	19653.0
2014-09-16 07:00:00	SPY	ETF	198.73	198.9	198.72	198.83	15600.0
2014-09-16 07:30:00	SPY	ETF	198.83	198.87	198.73	198.75	71598.0
2014-09-16 08:00:00	SPY	ETF	198.83	198.85	198.62	198.72	254024.0
2014-09-16 08:30:00	SPY	ETF	198.7	198.77	198.63	198.73	319556.0
2014-09-16 09:00:00	SPY	ETF	198.73	198.74	198.43	198.59	695822.0
2014-09-16 09:30:00	SPY	ETF	198.61	199.28	198.5	199.24	10962722.0
2014-09-16 10:00:00	SPY	ETF	199.24	199.53	199.18	199.33	9185077.0
2014-09-16 10:30:00	SPY	ETF	199.34	199.45	199.1705	199.225	6747598.0
2014-09-16 11:00:00	SPY	ETF	199.22	199.64	199.05	199.6	8151000.0
2014-09-16 11:30:00	SPY	ETF	199.6	200.337	199.57	200.19	13688813.0
2014-09-16 12:00:00	SPY	ETF	200.2	200.5	200.05	200.38	7449410.0
2014-09-16 12:30:00	SPY	ETF	200.37	200.52	200.28	200.32	4923325.0
2014-09-16 13:00:00	SPY	ETF	200.32	200.72	200.32	200.62	6156142.0
2014-09-16 13:30:00	SPY	ETF	200.63	200.84	200.62	200.68	5481880.0
2014-09-16 14:00:00	SPY	ETF	200.68	200.81	200.63	200.73	7657127.0
2014-09-16 14:30:00	SPY	ETF	200.73	200.8	200.58	200.62	5741047.0
2014-09-16 15:00:00	SPY	ETF	200.625	200.75	200.48	200.49	5731430.0
2014-09-16 15:30:00	SPY	ETF	200.495	200.62	200.47	200.49	11887940.0
2014-09-16 16:00:00	SPY	ETF	200.49	200.7192	200.4606	200.58	5191842.0
2014-09-16 16:30:00	SPY	ETF	200.56	200.57	200.1838	200.55	2110504.0
2014-09-16 17:00:00	SPY	ETF	200.56	200.57	200.46	200.54	339282.0
2014-09-16 17:30:00	SPY	ETF	200.56	200.56	200.52	200.53	16940.0
2014-09-16 18:00:00	SPY	ETF	200.53	200.6	200.52	200.58	28631.0
2014-09-16 18:30:00	SPY	ETF	200.58	200.58	200.53	200.53	23360.0
2014-09-16 19:00:00	SPY	ETF	200.53	200.55	200.51	200.54	23250.0
2014-09-16 19:30:00	SPY	ETF	200.55	200.59	200.51	200.58	78886.0
2014-09-16 04:00:00	QQQ	ETF	98.37	98.37	98.32	98.36	1600.0
2014-09-16 05:30:00	QQQ	ETF	98.39	98.43	98.39	98.43	68695.0
2014-09-16 06:00:00	QQQ	ETF	98.42	98.42	98.26	98.27	4617.0
2014-09-16 06:30:00	QQQ	ETF	98.37	98.38	98.37	98.38	3741.0
2014-09-16 07:00:00	QQQ	ETF	98.41	98.47	98.38	98.43	15885.0
2014-09-16 07:30:00	QQQ	ETF	98.45	98.45	98.37	98.37	45500.0
2014-09-16 08:00:00	QQQ	ETF	98.37	98.46	98.27	98.3	153032.0
2014-09-16 08:30:00	QQQ	ETF	98.31	98.37	98.28	98.36	141520.0
2014-09-16 09:00:00	QQQ	ETF	98.37	98.37	98.15	98.15	452537.0
2014-09-16 09:30:00	QQQ	ETF	98.16	98.62	98.05	98.52	5720175.0
2014-09-16 10:00:00	QQQ	ETF	98.52	98.78	98.43	98.65	2994603.0
2014-09-16 10:30:00	QQQ	ETF	98.655	98.71	98.47	98.49	1858040.0
2014-09-16 11:00:00	QQQ	ETF	98.49	98.7	98.33	98.66	2471286.0
2014-09-16 11:30:00	QQQ	ETF	98.67	99.07	98.64	99.01	2843612.0
2014-09-16 12:00:00	QQQ	ETF	99.01	99.14	98.94	99.11	1901120.0
2014-09-16 12:30:00	QQQ	ETF	99.1099	99.19	99.04	99.05	1278165.0
2014-09-16 13:00:00	QQQ	ETF	99.06	99.31	99.06	99.25	1642970.0
2014-09-16 13:30:00	QQQ	ETF	99.26	99.4399	99.26	99.3231	1465507.0

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

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