PREVIEW / etf_30min / 2014-01-06

all etf 30-min files

  file:    by_date/etf_30min/2014/2014-01-06.parquet
  size:    344 KB
  rows:    11,535

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-06 04:00:00	SPY	ETF	182.64	182.8	182.64	182.8	989.0
2014-01-06 04:30:00	SPY	ETF	182.88	182.91	182.88	182.91	1454.0
2014-01-06 05:00:00	SPY	ETF	182.99	183.02	182.9	183.01	5021.0
2014-01-06 05:30:00	SPY	ETF	183.01	183.03	183.0	183.0	3928.0
2014-01-06 06:00:00	SPY	ETF	182.99	183.1	182.99	183.06	1350.0
2014-01-06 06:30:00	SPY	ETF	183.12	183.13	183.09	183.1	59100.0
2014-01-06 07:00:00	SPY	ETF	183.04	183.25	183.04	183.25	45421.0
2014-01-06 07:30:00	SPY	ETF	183.26	183.32	183.16	183.17	61745.0
2014-01-06 08:00:00	SPY	ETF	183.17	183.27	183.15	183.24	146406.0
2014-01-06 08:30:00	SPY	ETF	183.24	183.28	183.15	183.26	113478.0
2014-01-06 09:00:00	SPY	ETF	183.26	183.5	183.26	183.47	778524.0
2014-01-06 09:30:00	SPY	ETF	183.47	183.56	182.72	182.9772	11182849.0
2014-01-06 10:00:00	SPY	ETF	182.97	183.1	182.7	183.01	11116478.0
2014-01-06 10:30:00	SPY	ETF	183.01	183.1	182.54	182.56	5546619.0
2014-01-06 11:00:00	SPY	ETF	182.565	182.68	182.08	182.29	11132654.0
2014-01-06 11:30:00	SPY	ETF	182.28	182.38	182.14	182.37	6878823.0
2014-01-06 12:00:00	SPY	ETF	182.37	182.44	182.249	182.3	2860168.0
2014-01-06 12:30:00	SPY	ETF	182.3	182.425	182.15	182.34	5167251.0
2014-01-06 13:00:00	SPY	ETF	182.35	182.43	182.18	182.32	3756256.0
2014-01-06 13:30:00	SPY	ETF	182.3296	182.79	182.25	182.675	4139050.0
2014-01-06 14:00:00	SPY	ETF	182.68	182.79	182.53	182.64	4038916.0
2014-01-06 14:30:00	SPY	ETF	182.64	182.93	182.61	182.855	5114382.0
2014-01-06 15:00:00	SPY	ETF	182.85	182.87	182.64	182.7973	4905834.0
2014-01-06 15:30:00	SPY	ETF	182.79	182.82	182.34	182.4	14552216.0
2014-01-06 16:00:00	SPY	ETF	182.4	183.47	182.3	182.38	7373941.0
2014-01-06 16:30:00	SPY	ETF	182.36	182.36	182.27	182.31	359155.0
2014-01-06 17:00:00	SPY	ETF	182.29	182.36	182.29	182.31	4163955.0
2014-01-06 17:30:00	SPY	ETF	182.31	182.33	182.3	182.33	92064.0
2014-01-06 18:00:00	SPY	ETF	182.33	182.45	182.33	182.41	657212.0
2014-01-06 18:30:00	SPY	ETF	182.41	182.5	182.38	182.38	250303.0
2014-01-06 19:00:00	SPY	ETF	182.4	182.42	182.4	182.4	8300.0
2014-01-06 19:30:00	SPY	ETF	182.38	182.41	182.36	182.385	222290.0
2014-01-06 05:30:00	QQQ	ETF	86.67	86.67	86.67	86.67	175.0
2014-01-06 06:00:00	QQQ	ETF	86.66	86.69	86.66	86.69	520.0
2014-01-06 06:30:00	QQQ	ETF	86.67	86.69	86.67	86.69	1100.0
2014-01-06 07:00:00	QQQ	ETF	86.64	86.64	86.64	86.64	5000.0
2014-01-06 07:30:00	QQQ	ETF	86.7	86.72	86.7	86.72	8050.0
2014-01-06 08:00:00	QQQ	ETF	86.72	86.75	86.62	86.62	116087.0
2014-01-06 08:30:00	QQQ	ETF	86.6	86.63	86.56	86.59	38266.0
2014-01-06 09:00:00	QQQ	ETF	86.635	86.66	86.63	86.64	176356.0
2014-01-06 09:30:00	QQQ	ETF	86.65	86.76	86.24	86.31	4137189.0
2014-01-06 10:00:00	QQQ	ETF	86.31	86.3249	86.135	86.31	2901198.0
2014-01-06 10:30:00	QQQ	ETF	86.31	86.35	86.15	86.18	2722708.0
2014-01-06 11:00:00	QQQ	ETF	86.18	86.29	86.0	86.1199	1944888.0
2014-01-06 11:30:00	QQQ	ETF	86.12	86.2	86.0501	86.2	969417.0
2014-01-06 12:00:00	QQQ	ETF	86.2	86.277	86.15	86.21	1177082.0
2014-01-06 12:30:00	QQQ	ETF	86.2	86.2735	86.1	86.23	1195117.0
2014-01-06 13:00:00	QQQ	ETF	86.23	86.26	86.1	86.17	892468.0
2014-01-06 13:30:00	QQQ	ETF	86.18	86.42	86.15	86.37	1455048.0
2014-01-06 14:00:00	QQQ	ETF	86.38	86.5	86.34	86.43	1537804.0

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

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