PREVIEW / etf_30min / 2014-10-24

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-24.parquet
  size:    352 KB
  rows:    11,977

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-10-24 04:00:00	SPY	ETF	194.84	195.07	194.75	194.8	43598.0
2014-10-24 04:30:00	SPY	ETF	194.8	194.97	194.72	194.84	26847.0
2014-10-24 05:00:00	SPY	ETF	194.8	194.82	194.61	194.69	24781.0
2014-10-24 05:30:00	SPY	ETF	194.68	194.81	194.63	194.68	19850.0
2014-10-24 06:00:00	SPY	ETF	194.7	194.73	194.39	194.54	24703.0
2014-10-24 06:30:00	SPY	ETF	194.57	194.63	194.43	194.52	50567.0
2014-10-24 07:00:00	SPY	ETF	194.54	194.71	194.45	194.51	216073.0
2014-10-24 07:30:00	SPY	ETF	194.57	194.57	194.32	194.48	302768.0
2014-10-24 08:00:00	SPY	ETF	193.8318	194.89	193.8318	194.82	922403.0
2014-10-24 08:30:00	SPY	ETF	194.79	195.06	192.62	194.88	1682767.0
2014-10-24 09:00:00	SPY	ETF	194.89	195.27	194.88	195.22	1208147.0
2014-10-24 09:30:00	SPY	ETF	195.25	195.82	194.9	195.0854	15942942.0
2014-10-24 10:00:00	SPY	ETF	195.1	195.47	194.49	195.02	14563418.0
2014-10-24 10:30:00	SPY	ETF	195.02	195.6	195.02	195.55	6544788.0
2014-10-24 11:00:00	SPY	ETF	195.56	195.74	195.35	195.6	5498397.0
2014-10-24 11:30:00	SPY	ETF	195.6	196.14	195.58	195.9499	7265105.0
2014-10-24 12:00:00	SPY	ETF	195.94	196.26	195.84	195.92	5274749.0
2014-10-24 12:30:00	SPY	ETF	195.92	196.05	195.59	195.71	4321118.0
2014-10-24 13:00:00	SPY	ETF	195.72	195.84	195.39	195.595	4953073.0
2014-10-24 13:30:00	SPY	ETF	195.595	195.97	195.53	195.88	3629729.0
2014-10-24 14:00:00	SPY	ETF	195.88	196.14	195.8	196.05	5232591.0
2014-10-24 14:30:00	SPY	ETF	196.05	196.21	195.92	196.09	4426037.0
2014-10-24 15:00:00	SPY	ETF	196.08	196.24	195.93	196.09	6314326.0
2014-10-24 15:30:00	SPY	ETF	196.1	196.49	196.05	196.38	15622144.0
2014-10-24 16:00:00	SPY	ETF	196.38	196.58	196.38	196.52	5126171.0
2014-10-24 16:30:00	SPY	ETF	196.52	196.61	196.3981	196.6	3849026.0
2014-10-24 17:00:00	SPY	ETF	196.6	196.67	196.56	196.62	283064.0
2014-10-24 17:30:00	SPY	ETF	196.64	196.64	196.43	196.51	118136.0
2014-10-24 18:00:00	SPY	ETF	196.5	196.52	196.43	196.49	667838.0
2014-10-24 18:30:00	SPY	ETF	196.49	196.5	196.43	196.43	35439.0
2014-10-24 19:00:00	SPY	ETF	196.49	196.51	196.45	196.5	5439.0
2014-10-24 19:30:00	SPY	ETF	196.49	196.6	196.48	196.6	31667.0
2014-10-24 04:00:00	QQQ	ETF	97.7	97.79	97.7	97.79	300.0
2014-10-24 04:30:00	QQQ	ETF	97.61	97.61	97.61	97.61	100.0
2014-10-24 05:00:00	QQQ	ETF	97.61	97.64	97.6	97.6	1000.0
2014-10-24 05:30:00	QQQ	ETF	97.6	97.62	97.57	97.57	11150.0
2014-10-24 06:00:00	QQQ	ETF	97.6	97.6	97.45	97.5	18600.0
2014-10-24 06:30:00	QQQ	ETF	97.52	97.58	97.47	97.49	19100.0
2014-10-24 07:00:00	QQQ	ETF	97.56	97.61	97.48	97.52	8521.0
2014-10-24 07:30:00	QQQ	ETF	97.53	97.55	97.45	97.52	22118.0
2014-10-24 08:00:00	QQQ	ETF	97.57	97.7	97.45	97.66	54779.0
2014-10-24 08:30:00	QQQ	ETF	97.68	97.81	97.48	97.81	236925.0
2014-10-24 09:00:00	QQQ	ETF	97.81	98.0	97.77	97.96	523894.0
2014-10-24 09:30:00	QQQ	ETF	97.97	98.27	97.82	97.93	6526236.0
2014-10-24 10:00:00	QQQ	ETF	97.93	98.12	97.64	97.94	3980840.0
2014-10-24 10:30:00	QQQ	ETF	97.94	98.25	97.94	98.22	1967344.0
2014-10-24 11:00:00	QQQ	ETF	98.22	98.27	98.07	98.14	1535169.0
2014-10-24 11:30:00	QQQ	ETF	98.15	98.38	98.14	98.3	2193460.0
2014-10-24 12:00:00	QQQ	ETF	98.3	98.4	98.21	98.2399	1454465.0
2014-10-24 12:30:00	QQQ	ETF	98.2373	98.3	98.09	98.13	1177827.0

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

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