PREVIEW / etf_30min / 2014-10-03

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-10-03.parquet
  size:    361 KB
  rows:    12,107

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-03 04:00:00	SPY	ETF	194.83	195.22	194.83	195.22	7774.0
2014-10-03 04:30:00	SPY	ETF	195.3	195.46	195.3	195.42	7411.0
2014-10-03 05:00:00	SPY	ETF	195.35	195.38	195.29	195.38	13816.0
2014-10-03 05:30:00	SPY	ETF	195.44	195.44	195.2	195.2	6056.0
2014-10-03 06:00:00	SPY	ETF	195.17	195.31	195.17	195.31	21671.0
2014-10-03 06:30:00	SPY	ETF	195.3	195.31	195.15	195.17	90301.0
2014-10-03 07:00:00	SPY	ETF	195.21	195.38	195.19	195.22	142681.0
2014-10-03 07:30:00	SPY	ETF	195.24	195.49	195.19	195.44	140326.0
2014-10-03 08:00:00	SPY	ETF	195.19	195.65	194.69	195.34	1168900.0
2014-10-03 08:30:00	SPY	ETF	195.4	195.9	195.13	195.33	5791099.0
2014-10-03 09:00:00	SPY	ETF	195.33	195.77	195.33	195.68	1540002.0
2014-10-03 09:30:00	SPY	ETF	195.68	196.22	195.08	196.03	18766866.0
2014-10-03 10:00:00	SPY	ETF	196.04	196.5	195.98	196.064	12428099.0
2014-10-03 10:30:00	SPY	ETF	196.06	196.08	195.72	196.03	8571074.0
2014-10-03 11:00:00	SPY	ETF	196.02	196.28	195.915	196.1665	5397811.0
2014-10-03 11:30:00	SPY	ETF	196.17	196.32	195.97	196.17	3987764.0
2014-10-03 12:00:00	SPY	ETF	196.17	196.54	196.05	196.52	4334206.0
2014-10-03 12:30:00	SPY	ETF	196.53	196.79	196.51	196.68	5626692.0
2014-10-03 13:00:00	SPY	ETF	196.67	196.7127	196.46	196.565	5444512.0
2014-10-03 13:30:00	SPY	ETF	196.57	196.58	196.32	196.48	4354191.0
2014-10-03 14:00:00	SPY	ETF	196.475	196.87	196.475	196.7575	4509234.0
2014-10-03 14:30:00	SPY	ETF	196.759	196.88	196.7	196.75	5499744.0
2014-10-03 15:00:00	SPY	ETF	196.75	196.94	196.58	196.68	5966435.0
2014-10-03 15:30:00	SPY	ETF	196.68	196.865	196.51	196.53	16084748.0
2014-10-03 16:00:00	SPY	ETF	196.51	196.75	195.2	196.57	8236704.0
2014-10-03 16:30:00	SPY	ETF	196.56	196.5729	196.48	196.48	1519703.0
2014-10-03 17:00:00	SPY	ETF	196.49	196.52	196.47	196.5	86123.0
2014-10-03 17:30:00	SPY	ETF	196.52	196.57	196.48	196.53	35896.0
2014-10-03 18:00:00	SPY	ETF	196.52	196.52	196.45	196.48	94019.0
2014-10-03 18:30:00	SPY	ETF	196.53	196.57	196.53	196.53	3850.0
2014-10-03 19:00:00	SPY	ETF	196.52	196.55	196.52	196.55	846.0
2014-10-03 19:30:00	SPY	ETF	196.53	196.53	196.5	196.52	2001.0
2014-10-03 04:00:00	QQQ	ETF	97.55	97.57	97.55	97.57	820.0
2014-10-03 04:30:00	QQQ	ETF	97.59	97.67	97.59	97.67	600.0
2014-10-03 05:30:00	QQQ	ETF	97.6	97.61	97.6	97.61	19900.0
2014-10-03 06:00:00	QQQ	ETF	97.54	97.62	97.54	97.62	15200.0
2014-10-03 06:30:00	QQQ	ETF	97.62	97.64	97.54	97.56	23420.0
2014-10-03 07:00:00	QQQ	ETF	97.54	97.63	97.54	97.63	5700.0
2014-10-03 07:30:00	QQQ	ETF	97.56	97.7	97.56	97.68	36150.0
2014-10-03 08:00:00	QQQ	ETF	97.67	97.78	97.2262	97.63	1392428.0
2014-10-03 08:30:00	QQQ	ETF	97.73	97.99	97.56	97.68	733561.0
2014-10-03 09:00:00	QQQ	ETF	97.68	97.84	97.21	97.75	382211.0
2014-10-03 09:30:00	QQQ	ETF	97.76	98.13	97.44	98.06	8112448.0
2014-10-03 10:00:00	QQQ	ETF	98.07	98.39	98.05	98.17	5807813.0
2014-10-03 10:30:00	QQQ	ETF	98.17	98.28	98.01	98.259	2773054.0
2014-10-03 11:00:00	QQQ	ETF	98.25	98.345	98.12	98.28	2060495.0
2014-10-03 11:30:00	QQQ	ETF	98.28	98.31	98.04	98.15	1266474.0
2014-10-03 12:00:00	QQQ	ETF	98.14	98.35	98.11	98.34	1291631.0
2014-10-03 12:30:00	QQQ	ETF	98.34	98.45	98.29	98.38	1333169.0
2014-10-03 13:00:00	QQQ	ETF	98.38	98.42	98.28	98.3156	980458.0

> showing 50 of 12,107 rows — these rows as CSV

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