PREVIEW / etf_30min / 2016-03-08

all etf 30-min files

  file:    by_date/etf_30min/2016/2016-03-08.parquet
  size:    394 KB
  rows:    13,342

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
2016-03-08 04:00:00	SPY	ETF	199.24	199.54	199.06	199.43	123122.0
2016-03-08 04:30:00	SPY	ETF	199.44	199.48	199.08	199.08	93455.0
2016-03-08 05:00:00	SPY	ETF	199.08	199.08	198.73	198.91	39255.0
2016-03-08 05:30:00	SPY	ETF	198.95	199.16	198.86	198.97	51702.0
2016-03-08 06:00:00	SPY	ETF	198.9	199.31	198.86	199.2	36293.0
2016-03-08 06:30:00	SPY	ETF	199.3	199.38	199.22	199.36	29999.0
2016-03-08 07:00:00	SPY	ETF	199.43	200.05	199.42	199.69	190237.0
2016-03-08 07:30:00	SPY	ETF	199.69	199.94	199.65	199.84	177314.0
2016-03-08 08:00:00	SPY	ETF	199.5	199.88	199.0	199.56	415212.0
2016-03-08 08:30:00	SPY	ETF	199.56	200.0	199.51	199.73	514470.0
2016-03-08 09:00:00	SPY	ETF	199.72	199.72	199.28	199.33	691720.0
2016-03-08 09:30:00	SPY	ETF	199.32	199.47	198.82	199.05	11670865.0
2016-03-08 10:00:00	SPY	ETF	199.05	199.35	198.65	198.66	7762013.0
2016-03-08 10:30:00	SPY	ETF	198.66	199.03	198.39	198.58	7369039.0
2016-03-08 11:00:00	SPY	ETF	198.59	199.25	198.545	199.035	6089454.0
2016-03-08 11:30:00	SPY	ETF	199.04	199.46	198.8401	199.28	4986254.0
2016-03-08 12:00:00	SPY	ETF	199.28	199.8	199.13	199.64	5828289.0
2016-03-08 12:30:00	SPY	ETF	199.65	199.755	199.26	199.455	5411328.0
2016-03-08 13:00:00	SPY	ETF	199.455	199.72	199.21	199.645	5883759.0
2016-03-08 13:30:00	SPY	ETF	199.645	199.92	199.57	199.66	5448029.0
2016-03-08 14:00:00	SPY	ETF	199.66	199.92	199.27	199.34	7601579.0
2016-03-08 14:30:00	SPY	ETF	199.34	199.41	198.96	199.13	6408191.0
2016-03-08 15:00:00	SPY	ETF	199.135	199.27	198.56	198.565	8846585.0
2016-03-08 15:30:00	SPY	ETF	198.56	198.79	198.21	198.36	22366982.0
2016-03-08 16:00:00	SPY	ETF	198.36	199.2715	198.34	198.87	7679115.0
2016-03-08 16:30:00	SPY	ETF	198.87	198.9	198.4	198.87	1638325.0
2016-03-08 17:00:00	SPY	ETF	198.84	198.85	198.8	198.83	52309.0
2016-03-08 17:30:00	SPY	ETF	198.83	198.88	198.75	198.76	64242.0
2016-03-08 18:00:00	SPY	ETF	198.77	198.93	198.63	198.67	97692.0
2016-03-08 18:30:00	SPY	ETF	198.69	198.9923	198.69	198.71	45383.0
2016-03-08 19:00:00	SPY	ETF	198.72	198.84	198.5	198.82	57998.0
2016-03-08 19:30:00	SPY	ETF	198.83	198.86	198.65	198.65	72200.0
2016-03-08 04:00:00	QQQ	ETF	104.15	104.15	104.03	104.15	4698.0
2016-03-08 04:30:00	QQQ	ETF	104.06	104.06	104.06	104.06	100.0
2016-03-08 05:00:00	QQQ	ETF	103.96	103.96	103.96	103.96	300.0
2016-03-08 06:00:00	QQQ	ETF	103.96	104.18	103.91	104.14	1094.0
2016-03-08 06:30:00	QQQ	ETF	104.24	104.24	104.2	104.2	3398.0
2016-03-08 07:00:00	QQQ	ETF	104.45	104.67	104.43	104.43	21942.0
2016-03-08 07:30:00	QQQ	ETF	104.52	104.63	104.49	104.62	12940.0
2016-03-08 08:00:00	QQQ	ETF	104.57	104.57	104.38	104.42	38870.0
2016-03-08 08:30:00	QQQ	ETF	104.43	104.71	104.41	104.52	45271.0
2016-03-08 09:00:00	QQQ	ETF	104.55	104.55	104.27	104.29	82130.0
2016-03-08 09:30:00	QQQ	ETF	104.3	104.87	104.03	104.6	4744154.0
2016-03-08 10:00:00	QQQ	ETF	104.59	104.8099	104.24	104.26	2319576.0
2016-03-08 10:30:00	QQQ	ETF	104.26	104.5	104.1599	104.41	2128545.0
2016-03-08 11:00:00	QQQ	ETF	104.42	104.81	104.37	104.6899	2092881.0
2016-03-08 11:30:00	QQQ	ETF	104.68	104.94	104.51	104.89	2133155.0
2016-03-08 12:00:00	QQQ	ETF	104.8875	105.2	104.76	105.01	1856893.0
2016-03-08 12:30:00	QQQ	ETF	105.02	105.08	104.77	104.86	1018670.0
2016-03-08 13:00:00	QQQ	ETF	104.87	105.06	104.71	105.02	973641.0

> showing 50 of 13,342 rows — these rows as CSV

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