PREVIEW / etf_30min / 2014-01-07

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-07.parquet
  size:    336 KB
  rows:    11,399

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-01-07 04:00:00	SPY	ETF	182.83	182.9	182.82	182.87	8330.0
2014-01-07 04:30:00	SPY	ETF	182.84	182.9	182.84	182.9	766.0
2014-01-07 05:00:00	SPY	ETF	182.9	183.09	182.9	183.09	16700.0
2014-01-07 05:30:00	SPY	ETF	183.14	183.14	183.05	183.12	18560.0
2014-01-07 06:00:00	SPY	ETF	183.1	183.14	183.0	183.01	77725.0
2014-01-07 06:30:00	SPY	ETF	182.96	183.04	182.95	182.95	13058.0
2014-01-07 07:00:00	SPY	ETF	182.96	183.12	182.92	183.12	61643.0
2014-01-07 07:30:00	SPY	ETF	183.13	183.18	182.98	183.03	261967.0
2014-01-07 08:00:00	SPY	ETF	183.02	183.13	182.94	183.13	146402.0
2014-01-07 08:30:00	SPY	ETF	183.11	183.13	182.96	183.1	277068.0
2014-01-07 09:00:00	SPY	ETF	183.08	183.15	183.01	183.08	554058.0
2014-01-07 09:30:00	SPY	ETF	183.09	183.51	182.95	183.49	14121620.0
2014-01-07 10:00:00	SPY	ETF	183.49	183.65	183.44	183.5499	7007822.0
2014-01-07 10:30:00	SPY	ETF	183.545	183.79	183.53	183.625	5488673.0
2014-01-07 11:00:00	SPY	ETF	183.625	183.66	183.46	183.48	3296349.0
2014-01-07 11:30:00	SPY	ETF	183.48	183.57	183.36	183.4001	5538824.0
2014-01-07 12:00:00	SPY	ETF	183.405	183.47	183.32	183.44	2348650.0
2014-01-07 12:30:00	SPY	ETF	183.44	183.6	183.42	183.5899	2991288.0
2014-01-07 13:00:00	SPY	ETF	183.585	183.61	183.52	183.56	1667717.0
2014-01-07 13:30:00	SPY	ETF	183.56	183.65	183.33	183.355	3134757.0
2014-01-07 14:00:00	SPY	ETF	183.351	183.4	183.14	183.385	6005980.0
2014-01-07 14:30:00	SPY	ETF	183.39	183.555	183.38	183.486	3384184.0
2014-01-07 15:00:00	SPY	ETF	183.485	183.65	183.485	183.595	6607441.0
2014-01-07 15:30:00	SPY	ETF	183.6	183.73	183.44	183.44	12780240.0
2014-01-07 16:00:00	SPY	ETF	183.44	183.524	182.4242	183.39	7067992.0
2014-01-07 16:30:00	SPY	ETF	183.4	183.4	182.4243	183.35	658135.0
2014-01-07 17:00:00	SPY	ETF	183.37	183.4	182.4243	183.39	1058159.0
2014-01-07 17:30:00	SPY	ETF	183.42	183.42	183.35	183.39	35968.0
2014-01-07 18:00:00	SPY	ETF	183.39	183.4	183.37	183.37	11632.0
2014-01-07 18:30:00	SPY	ETF	183.4	183.42	183.39	183.39	1400.0
2014-01-07 19:00:00	SPY	ETF	183.38	183.38	183.28	183.31	56560.0
2014-01-07 19:30:00	SPY	ETF	183.33	183.33	183.28	183.29	34069.0
2014-01-07 05:00:00	QQQ	ETF	86.55	86.64	86.55	86.64	320.0
2014-01-07 05:30:00	QQQ	ETF	86.66	86.66	86.66	86.66	2000.0
2014-01-07 06:30:00	QQQ	ETF	86.6	86.62	86.6	86.62	1000.0
2014-01-07 07:00:00	QQQ	ETF	86.63	86.68	86.63	86.68	3700.0
2014-01-07 07:30:00	QQQ	ETF	86.7	86.7	86.65	86.65	5500.0
2014-01-07 08:00:00	QQQ	ETF	86.67	86.72	86.32	86.72	91097.0
2014-01-07 08:30:00	QQQ	ETF	86.71	86.71	86.66	86.69	33940.0
2014-01-07 09:00:00	QQQ	ETF	86.68	86.71	86.66	86.69	56267.0
2014-01-07 09:30:00	QQQ	ETF	86.7	86.95	86.56	86.9401	3715956.0
2014-01-07 10:00:00	QQQ	ETF	86.949	87.07	86.93	87.02	2213602.0
2014-01-07 10:30:00	QQQ	ETF	87.03	87.11	87.0	87.07	1287006.0
2014-01-07 11:00:00	QQQ	ETF	87.07	87.1	87.0	87.0099	1244546.0
2014-01-07 11:30:00	QQQ	ETF	87.0	87.07	86.91	86.9493	899179.0
2014-01-07 12:00:00	QQQ	ETF	86.9499	86.99	86.89	86.99	795543.0
2014-01-07 12:30:00	QQQ	ETF	86.995	87.09	86.9803	87.06	1037311.0
2014-01-07 13:00:00	QQQ	ETF	87.06	87.11	87.0301	87.11	432694.0
2014-01-07 13:30:00	QQQ	ETF	87.1	87.14	86.975	86.99	611930.0
2014-01-07 14:00:00	QQQ	ETF	86.98	87.0	86.841	86.9199	1380485.0

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

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