PREVIEW / etf_30min / 2018-12-14

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-12-14.parquet
  size:    501 KB
  rows:    17,409

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
2018-12-14 04:00:00	SPY	ETF	262.24	262.35	261.89	261.89	51333.0
2018-12-14 04:30:00	SPY	ETF	261.93	262.15	261.8	262.1	31921.0
2018-12-14 05:00:00	SPY	ETF	262.15	262.72	262.15	262.65	81483.0
2018-12-14 05:30:00	SPY	ETF	262.6	262.74	262.4	262.6	67233.0
2018-12-14 06:00:00	SPY	ETF	262.62	262.87	262.51	262.75	85658.0
2018-12-14 06:30:00	SPY	ETF	262.75	262.95	262.55	262.8	120468.0
2018-12-14 07:00:00	SPY	ETF	262.83	262.93	262.48	262.8	167161.0
2018-12-14 07:30:00	SPY	ETF	262.75	263.05	262.73	262.82	217104.0
2018-12-14 08:00:00	SPY	ETF	263.4	263.4	262.02	262.56	361252.0
2018-12-14 08:30:00	SPY	ETF	262.67	263.23	262.6	263.08	395993.0
2018-12-14 09:00:00	SPY	ETF	263.12	263.15	262.88	262.92	254195.0
2018-12-14 09:30:00	SPY	ETF	262.96	263.84	262.57	263.66	10938579.0
2018-12-14 10:00:00	SPY	ETF	263.66	264.03	263.04	263.06	5594165.0
2018-12-14 10:30:00	SPY	ETF	263.055	263.71	262.39	263.03	7233132.0
2018-12-14 11:00:00	SPY	ETF	263.04	263.53	262.03	262.24	6915478.0
2018-12-14 11:30:00	SPY	ETF	262.25	262.81	261.05	261.24	9579805.0
2018-12-14 12:00:00	SPY	ETF	261.2266	262.03	261.1675	261.93	6546355.0
2018-12-14 12:30:00	SPY	ETF	261.9201	262.4	261.56	261.74	4150598.0
2018-12-14 13:00:00	SPY	ETF	261.73	262.25	261.36	261.57	4033395.0
2018-12-14 13:30:00	SPY	ETF	261.57	261.63	260.84	261.11	5491441.0
2018-12-14 14:00:00	SPY	ETF	261.11	261.59	260.85	261.32	4690622.0
2018-12-14 14:30:00	SPY	ETF	261.33	261.39	260.0	260.7388	10100090.0
2018-12-14 15:00:00	SPY	ETF	260.735	261.37	260.43	260.5605	7995700.0
2018-12-14 15:30:00	SPY	ETF	260.56	260.81	259.85	260.49	19596318.0
2018-12-14 16:00:00	SPY	ETF	260.5	260.82	260.37	260.5	8726461.0
2018-12-14 16:30:00	SPY	ETF	260.49	260.54	260.04	260.11	791089.0
2018-12-14 17:00:00	SPY	ETF	260.1	260.47	260.1	260.2	746921.0
2018-12-14 17:30:00	SPY	ETF	260.2	260.47	260.07	260.1	180025.0
2018-12-14 18:00:00	SPY	ETF	260.11	260.11	259.91	259.91	55576.0
2018-12-14 18:30:00	SPY	ETF	259.96	260.02	259.91	259.96	32945.0
2018-12-14 19:00:00	SPY	ETF	259.93	259.94	259.83	259.89	25469.0
2018-12-14 19:30:00	SPY	ETF	259.83	259.91	259.75	259.83	18810.0
2018-12-14 04:00:00	QQQ	ETF	162.81	162.83	162.37	162.37	42868.0
2018-12-14 04:30:00	QQQ	ETF	162.37	162.6	162.27	162.5	20039.0
2018-12-14 05:00:00	QQQ	ETF	162.81	162.96	162.73	162.93	34137.0
2018-12-14 05:30:00	QQQ	ETF	162.9	163.0	162.82	162.96	9446.0
2018-12-14 06:00:00	QQQ	ETF	163.09	163.09	162.91	163.0	7860.0
2018-12-14 06:30:00	QQQ	ETF	163.0	163.26	162.93	163.18	21895.0
2018-12-14 07:00:00	QQQ	ETF	163.17	163.32	163.02	163.32	106924.0
2018-12-14 07:30:00	QQQ	ETF	163.18	163.33	163.03	163.15	86337.0
2018-12-14 08:00:00	QQQ	ETF	163.0901	163.33	162.37	162.92	110511.0
2018-12-14 08:30:00	QQQ	ETF	162.91	163.42	162.88	163.21	221414.0
2018-12-14 09:00:00	QQQ	ETF	163.26	163.43	163.15	163.21	132324.0
2018-12-14 09:30:00	QQQ	ETF	163.19	163.42	162.37	163.24	4798555.0
2018-12-14 10:00:00	QQQ	ETF	163.22	163.75	162.92	163.06	2939318.0
2018-12-14 10:30:00	QQQ	ETF	163.03	163.81	162.75	163.37	2566974.0
2018-12-14 11:00:00	QQQ	ETF	163.37	163.78	162.81	163.01	2896619.0
2018-12-14 11:30:00	QQQ	ETF	163.02	163.41	162.06	162.2	3754585.0
2018-12-14 12:00:00	QQQ	ETF	162.19	162.66	162.08	162.59	3482441.0
2018-12-14 12:30:00	QQQ	ETF	162.5885	162.9	162.32	162.39	1431905.0

> showing 50 of 17,409 rows — these rows as CSV

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