PREVIEW / etf_30min / 2014-06-04

all etf 30-min files

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

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-06-04 04:00:00	SPY	ETF	192.77	192.81	192.74	192.81	51288.0
2014-06-04 04:30:00	SPY	ETF	192.71	192.71	192.44	192.44	1374.0
2014-06-04 05:00:00	SPY	ETF	192.46	192.46	192.35	192.37	3269.0
2014-06-04 05:30:00	SPY	ETF	192.48	192.48	192.41	192.44	6423.0
2014-06-04 06:00:00	SPY	ETF	192.43	192.56	192.43	192.54	18656.0
2014-06-04 06:30:00	SPY	ETF	192.58	192.62	192.45	192.59	21070.0
2014-06-04 07:00:00	SPY	ETF	192.63	192.63	192.55	192.57	11149.0
2014-06-04 07:30:00	SPY	ETF	192.54	192.62	192.5	192.56	93303.0
2014-06-04 08:00:00	SPY	ETF	192.59	192.84	192.34	192.47	613175.0
2014-06-04 08:30:00	SPY	ETF	192.46	192.81	192.23	192.35	269131.0
2014-06-04 09:00:00	SPY	ETF	192.35	192.48	192.35	192.47	472344.0
2014-06-04 09:30:00	SPY	ETF	192.47	192.69	192.265	192.67	7001736.0
2014-06-04 10:00:00	SPY	ETF	192.67	192.83	192.58	192.625	5398189.0
2014-06-04 10:30:00	SPY	ETF	192.62	193.0	192.6	192.99	3010790.0
2014-06-04 11:00:00	SPY	ETF	192.98	193.22	192.95	193.18	4833128.0
2014-06-04 11:30:00	SPY	ETF	193.18	193.18	193.05	193.08	2419701.0
2014-06-04 12:00:00	SPY	ETF	193.08	193.16	193.06	193.13	1433826.0
2014-06-04 12:30:00	SPY	ETF	193.14	193.27	193.08	193.24	1371107.0
2014-06-04 13:00:00	SPY	ETF	193.24	193.3	193.17	193.19	2363790.0
2014-06-04 13:30:00	SPY	ETF	193.2	193.27	193.16	193.2501	1510902.0
2014-06-04 14:00:00	SPY	ETF	193.2599	193.28	193.09	193.14	4671694.0
2014-06-04 14:30:00	SPY	ETF	193.145	193.18	193.01	193.11	2545015.0
2014-06-04 15:00:00	SPY	ETF	193.105	193.18	193.08	193.16	2862924.0
2014-06-04 15:30:00	SPY	ETF	193.16	193.27	193.14	193.17	9983732.0
2014-06-04 16:00:00	SPY	ETF	193.17	193.27	193.16	193.16	3557367.0
2014-06-04 16:30:00	SPY	ETF	193.16	193.22	193.12	193.2	73455.0
2014-06-04 17:00:00	SPY	ETF	193.21	193.24	193.19	193.19	61128.0
2014-06-04 17:30:00	SPY	ETF	193.2	193.26	193.2	193.26	58419.0
2014-06-04 18:00:00	SPY	ETF	193.27	193.27	193.11	193.11	370385.0
2014-06-04 18:30:00	SPY	ETF	193.11	193.13	193.1	193.12	5850.0
2014-06-04 19:00:00	SPY	ETF	193.13	193.13	193.11	193.11	5168.0
2014-06-04 19:30:00	SPY	ETF	193.11	193.2	193.11	193.17	22115.0
2014-06-04 04:30:00	QQQ	ETF	91.1	91.1	91.03	91.03	3900.0
2014-06-04 05:00:00	QQQ	ETF	91.03	91.03	91.03	91.03	60000.0
2014-06-04 07:00:00	QQQ	ETF	91.12	91.12	91.11	91.11	1000.0
2014-06-04 07:30:00	QQQ	ETF	91.07	91.07	91.07	91.07	1000.0
2014-06-04 08:00:00	QQQ	ETF	91.09	91.1	90.96	91.02	76572.0
2014-06-04 08:30:00	QQQ	ETF	91.01	91.18	90.88	90.95	80905.0
2014-06-04 09:00:00	QQQ	ETF	90.94	91.0	90.94	90.97	37152.0
2014-06-04 09:30:00	QQQ	ETF	90.96	91.18	90.81	91.1699	3384612.0
2014-06-04 10:00:00	QQQ	ETF	91.17	91.28	91.09	91.18	2740907.0
2014-06-04 10:30:00	QQQ	ETF	91.17	91.37	91.16	91.37	1267705.0
2014-06-04 11:00:00	QQQ	ETF	91.37	91.5	91.32	91.48	1156204.0
2014-06-04 11:30:00	QQQ	ETF	91.48	91.49	91.41	91.43	605197.0
2014-06-04 12:00:00	QQQ	ETF	91.44	91.53	91.42	91.52	808700.0
2014-06-04 12:30:00	QQQ	ETF	91.521	91.65	91.495	91.62	1310797.0
2014-06-04 13:00:00	QQQ	ETF	91.62	91.67	91.58	91.59	512183.0
2014-06-04 13:30:00	QQQ	ETF	91.59	91.66	91.57	91.65	493704.0
2014-06-04 14:00:00	QQQ	ETF	91.65	91.66	91.5	91.55	985984.0
2014-06-04 14:30:00	QQQ	ETF	91.54	91.55	91.45	91.52	757220.0

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

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