PREVIEW / etf_30min / 2014-08-15

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-08-15.parquet
  size:    344 KB
  rows:    11,440

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-08-15 04:00:00	SPY	ETF	196.03	196.18	196.03	196.1	4532.0
2014-08-15 04:30:00	SPY	ETF	196.25	196.43	196.21	196.43	3576.0
2014-08-15 05:00:00	SPY	ETF	196.43	196.49	196.3	196.35	9075.0
2014-08-15 05:30:00	SPY	ETF	196.42	196.51	196.38	196.38	26704.0
2014-08-15 06:00:00	SPY	ETF	196.38	196.39	196.28	196.34	6176.0
2014-08-15 06:30:00	SPY	ETF	196.36	196.45	196.36	196.4	58744.0
2014-08-15 07:00:00	SPY	ETF	196.44	196.49	196.38	196.43	139078.0
2014-08-15 07:30:00	SPY	ETF	196.45	196.45	196.3	196.35	46441.0
2014-08-15 08:00:00	SPY	ETF	196.35	196.43	196.3	196.35	243853.0
2014-08-15 08:30:00	SPY	ETF	196.33	196.42	196.3	196.3	228393.0
2014-08-15 09:00:00	SPY	ETF	196.31	196.49	196.18	196.47	863613.0
2014-08-15 09:30:00	SPY	ETF	196.47	196.5	196.2	196.42	13043683.0
2014-08-15 10:00:00	SPY	ETF	196.42	196.585	196.34	196.51	7941318.0
2014-08-15 10:30:00	SPY	ETF	196.52	196.65	194.74	195.39	27464654.0
2014-08-15 11:00:00	SPY	ETF	195.4	195.76	195.04	195.07	16941691.0
2014-08-15 11:30:00	SPY	ETF	195.08	195.38	194.31	194.69	13533240.0
2014-08-15 12:00:00	SPY	ETF	194.7	195.22	194.43	195.18	8302329.0
2014-08-15 12:30:00	SPY	ETF	195.18	195.37	194.91	195.1	6021470.0
2014-08-15 13:00:00	SPY	ETF	195.1	195.27	194.85	195.19	5652496.0
2014-08-15 13:30:00	SPY	ETF	195.19	195.195	194.81	194.9	5308216.0
2014-08-15 14:00:00	SPY	ETF	194.9	195.59	194.89	195.57	5976093.0
2014-08-15 14:30:00	SPY	ETF	195.58	195.75	195.45	195.5189	6170461.0
2014-08-15 15:00:00	SPY	ETF	195.51	195.59	195.35	195.44	4767627.0
2014-08-15 15:30:00	SPY	ETF	195.43	195.87	195.4	195.73	10437137.0
2014-08-15 16:00:00	SPY	ETF	195.73	195.88	195.5134	195.78	4533626.0
2014-08-15 16:30:00	SPY	ETF	195.79	195.95	195.6894	195.83	1291281.0
2014-08-15 17:00:00	SPY	ETF	195.82	195.94	195.82	195.86	104213.0
2014-08-15 17:30:00	SPY	ETF	195.85	195.85	195.72	195.8	23053.0
2014-08-15 18:00:00	SPY	ETF	195.84	195.88	195.84	195.84	1772.0
2014-08-15 18:30:00	SPY	ETF	195.84	195.84	195.7	195.75	52908.0
2014-08-15 19:00:00	SPY	ETF	195.75	195.78	195.73	195.75	5640.0
2014-08-15 19:30:00	SPY	ETF	195.78	195.84	195.78	195.84	10122.0
2014-08-15 04:00:00	QQQ	ETF	97.1	97.15	97.1	97.15	2600.0
2014-08-15 04:30:00	QQQ	ETF	97.2	97.22	97.2	97.22	300.0
2014-08-15 05:00:00	QQQ	ETF	97.3	97.3	97.3	97.3	100.0
2014-08-15 05:30:00	QQQ	ETF	97.29	97.3	97.28	97.3	14500.0
2014-08-15 06:00:00	QQQ	ETF	97.26	97.26	97.25	97.25	3250.0
2014-08-15 06:30:00	QQQ	ETF	97.3	97.34	97.3	97.3	31620.0
2014-08-15 07:00:00	QQQ	ETF	97.32	97.35	97.3	97.34	37285.0
2014-08-15 07:30:00	QQQ	ETF	97.32	97.32	97.27	97.28	11520.0
2014-08-15 08:00:00	QQQ	ETF	97.28	97.35	97.26	97.31	118380.0
2014-08-15 08:30:00	QQQ	ETF	97.3	97.34	97.27	97.29	126378.0
2014-08-15 09:00:00	QQQ	ETF	97.29	97.52	97.24	97.45	1262291.0
2014-08-15 09:30:00	QQQ	ETF	97.46	97.58	97.38	97.4689	5144603.0
2014-08-15 10:00:00	QQQ	ETF	97.46	97.61	97.44	97.57	2549557.0
2014-08-15 10:30:00	QQQ	ETF	97.579	97.63	96.745	97.02	7748409.0
2014-08-15 11:00:00	QQQ	ETF	97.01	97.22	96.9	96.93	5106737.0
2014-08-15 11:30:00	QQQ	ETF	96.93	96.98	96.48	96.66	3804490.0
2014-08-15 12:00:00	QQQ	ETF	96.65	96.89	96.53	96.87	2919553.0
2014-08-15 12:30:00	QQQ	ETF	96.87	97.0599	96.78	96.93	1526755.0

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

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