PREVIEW / etf_30min / 2014-04-21

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-04-21.parquet
  size:    324 KB
  rows:    11,148

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-04-21 05:00:00	SPY	ETF	186.58	186.58	186.58	186.58	2980.0
2014-04-21 05:30:00	SPY	ETF	186.54	186.54	186.54	186.54	400.0
2014-04-21 06:00:00	SPY	ETF	186.53	186.53	186.49	186.53	1500.0
2014-04-21 06:30:00	SPY	ETF	186.54	186.61	186.54	186.59	2100.0
2014-04-21 07:00:00	SPY	ETF	186.61	186.65	186.58	186.65	48101.0
2014-04-21 07:30:00	SPY	ETF	186.62	186.69	186.55	186.58	25178.0
2014-04-21 08:00:00	SPY	ETF	186.58	186.67	186.39	186.4	368951.0
2014-04-21 08:30:00	SPY	ETF	186.42	186.46	186.3	186.44	377573.0
2014-04-21 09:00:00	SPY	ETF	186.44	186.51	186.42	186.44	398508.0
2014-04-21 09:30:00	SPY	ETF	186.44	186.84	186.34	186.77	7311248.0
2014-04-21 10:00:00	SPY	ETF	186.77	187.0	186.5259	186.65	5993127.0
2014-04-21 10:30:00	SPY	ETF	186.64	186.64	186.21	186.45	5640840.0
2014-04-21 11:00:00	SPY	ETF	186.45	186.84	186.38	186.74	4568910.0
2014-04-21 11:30:00	SPY	ETF	186.73	186.86	186.67	186.83	2243242.0
2014-04-21 12:00:00	SPY	ETF	186.82	186.91	186.68	186.7649	2518397.0
2014-04-21 12:30:00	SPY	ETF	186.77	186.83	186.66	186.8	1842865.0
2014-04-21 13:00:00	SPY	ETF	186.8	186.91	186.72	186.89	1787013.0
2014-04-21 13:30:00	SPY	ETF	186.89	186.97	186.81	186.97	2907801.0
2014-04-21 14:00:00	SPY	ETF	186.98	187.04	186.9	186.99	3137817.0
2014-04-21 14:30:00	SPY	ETF	186.9951	187.1	186.95	187.055	3489505.0
2014-04-21 15:00:00	SPY	ETF	187.06	187.065	186.82	186.86	4417182.0
2014-04-21 15:30:00	SPY	ETF	186.86	187.08	186.79	187.05	8118139.0
2014-04-21 16:00:00	SPY	ETF	187.06	187.12	186.97	187.0	3779567.0
2014-04-21 16:30:00	SPY	ETF	187.0	187.06	186.95	187.02	804494.0
2014-04-21 17:00:00	SPY	ETF	187.03	187.1	186.97	187.07	135674.0
2014-04-21 17:30:00	SPY	ETF	187.07	187.11	187.02	187.05	53504.0
2014-04-21 18:00:00	SPY	ETF	187.03	187.12	187.02	187.08	35069.0
2014-04-21 18:30:00	SPY	ETF	187.11	187.11	187.05	187.08	3450.0
2014-04-21 19:00:00	SPY	ETF	187.06	187.07	187.05	187.05	8870.0
2014-04-21 19:30:00	SPY	ETF	187.05	187.07	187.05	187.07	68750.0
2014-04-21 06:30:00	QQQ	ETF	86.37	86.37	86.37	86.37	200.0
2014-04-21 07:00:00	QQQ	ETF	86.36	86.39	86.36	86.39	1100.0
2014-04-21 07:30:00	QQQ	ETF	86.41	86.44	86.41	86.44	800.0
2014-04-21 08:00:00	QQQ	ETF	86.36	86.47	86.36	86.38	93980.0
2014-04-21 08:30:00	QQQ	ETF	86.47	86.47	86.32	86.36	37450.0
2014-04-21 09:00:00	QQQ	ETF	86.35	86.42	86.35	86.4	172688.0
2014-04-21 09:30:00	QQQ	ETF	86.41	86.6	86.22	86.43	4492327.0
2014-04-21 10:00:00	QQQ	ETF	86.42	86.73	86.25	86.29	3486191.0
2014-04-21 10:30:00	QQQ	ETF	86.29	86.34	86.0	86.2701	2771912.0
2014-04-21 11:00:00	QQQ	ETF	86.27	86.52	86.22	86.43	1430041.0
2014-04-21 11:30:00	QQQ	ETF	86.43	86.62	86.38	86.57	1142212.0
2014-04-21 12:00:00	QQQ	ETF	86.575	86.63	86.48	86.53	769906.0
2014-04-21 12:30:00	QQQ	ETF	86.53	86.63	86.44	86.59	936061.0
2014-04-21 13:00:00	QQQ	ETF	86.6	86.73	86.53	86.7126	894413.0
2014-04-21 13:30:00	QQQ	ETF	86.719	86.75	86.6	86.75	1000851.0
2014-04-21 14:00:00	QQQ	ETF	86.74	86.79	86.69	86.785	921967.0
2014-04-21 14:30:00	QQQ	ETF	86.7801	86.84	86.72	86.81	1150675.0
2014-04-21 15:00:00	QQQ	ETF	86.82	86.82	86.64	86.69	1400163.0
2014-04-21 15:30:00	QQQ	ETF	86.68	86.84	86.63	86.83	2358317.0
2014-04-21 16:00:00	QQQ	ETF	86.84	86.92	86.4909	86.88	695055.0

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

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