PREVIEW / etf_30min / 2018-01-17

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-17.parquet
  size:    496 KB
  rows:    16,960

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-01-17 04:00:00	SPY	ETF	278.11	278.14	278.03	278.06	97015.0
2018-01-17 04:30:00	SPY	ETF	278.0	278.04	277.98	278.03	3700.0
2018-01-17 05:00:00	SPY	ETF	278.1	278.15	277.98	277.98	20999.0
2018-01-17 05:30:00	SPY	ETF	278.0	278.19	278.0	278.16	27257.0
2018-01-17 06:00:00	SPY	ETF	278.19	278.45	278.19	278.41	175848.0
2018-01-17 06:30:00	SPY	ETF	278.46	278.47	278.33	278.44	237596.0
2018-01-17 07:00:00	SPY	ETF	278.41	278.46	278.31	278.36	197124.0
2018-01-17 07:30:00	SPY	ETF	278.38	278.38	278.29	278.35	301178.0
2018-01-17 08:00:00	SPY	ETF	278.33	278.45	278.2	278.25	279107.0
2018-01-17 08:30:00	SPY	ETF	278.25	278.47	278.25	278.44	262446.0
2018-01-17 09:00:00	SPY	ETF	278.45	278.55	278.01	278.02	585414.0
2018-01-17 09:30:00	SPY	ETF	278.03	278.07	277.19	277.28	8225247.0
2018-01-17 10:00:00	SPY	ETF	277.28	278.0	277.2725	277.63	4628382.0
2018-01-17 10:30:00	SPY	ETF	277.63	277.98	277.58	277.93	3928415.0
2018-01-17 11:00:00	SPY	ETF	277.9311	278.48	277.78	278.27	5948839.0
2018-01-17 11:30:00	SPY	ETF	278.27	278.465	278.25	278.42	4897352.0
2018-01-17 12:00:00	SPY	ETF	278.42	278.71	278.4	278.64	4824285.0
2018-01-17 12:30:00	SPY	ETF	278.65	279.05	278.63	279.02	4432208.0
2018-01-17 13:00:00	SPY	ETF	279.02	279.195	278.93	279.0735	3310849.0
2018-01-17 13:30:00	SPY	ETF	279.07	279.31	279.03	279.175	4462951.0
2018-01-17 14:00:00	SPY	ETF	279.175	279.66	279.1749	279.5	5541166.0
2018-01-17 14:30:00	SPY	ETF	279.495	279.87	279.49	279.81	6585286.0
2018-01-17 15:00:00	SPY	ETF	279.81	280.05	279.6	279.64	9351740.0
2018-01-17 15:30:00	SPY	ETF	279.63	279.96	279.33	279.61	16834326.0
2018-01-17 16:00:00	SPY	ETF	279.61	279.65	278.8071	279.56	22637300.0
2018-01-17 16:30:00	SPY	ETF	279.55	279.69	279.04	279.5	950580.0
2018-01-17 17:00:00	SPY	ETF	279.51	279.59	279.51	279.59	119742.0
2018-01-17 17:30:00	SPY	ETF	279.57	279.6	279.52	279.52	52099.0
2018-01-17 18:00:00	SPY	ETF	279.51	279.71	279.44	279.71	219506.0
2018-01-17 18:30:00	SPY	ETF	279.74	279.88	279.67	279.8	130608.0
2018-01-17 19:00:00	SPY	ETF	279.8	279.8	279.7	279.76	16018.0
2018-01-17 19:30:00	SPY	ETF	279.74	279.85	279.74	279.78	16522.0
2018-01-17 04:00:00	QQQ	ETF	164.56	164.69	164.56	164.63	25800.0
2018-01-17 04:30:00	QQQ	ETF	164.65	164.74	164.65	164.74	7400.0
2018-01-17 05:00:00	QQQ	ETF	164.77	164.79	164.68	164.69	14700.0
2018-01-17 05:30:00	QQQ	ETF	164.69	164.84	164.69	164.82	17289.0
2018-01-17 06:00:00	QQQ	ETF	164.84	165.01	164.84	165.01	41598.0
2018-01-17 06:30:00	QQQ	ETF	164.98	165.01	164.88	164.89	47198.0
2018-01-17 07:00:00	QQQ	ETF	164.93	164.99	164.83	164.92	84114.0
2018-01-17 07:30:00	QQQ	ETF	164.91	164.92	164.8	164.81	50506.0
2018-01-17 08:00:00	QQQ	ETF	164.84	164.92	164.77	164.83	60283.0
2018-01-17 08:30:00	QQQ	ETF	164.83	165.1	164.81	165.08	179599.0
2018-01-17 09:00:00	QQQ	ETF	165.06	165.11	164.74	164.78	654017.0
2018-01-17 09:30:00	QQQ	ETF	164.77	164.87	164.03	164.245	5189975.0
2018-01-17 10:00:00	QQQ	ETF	164.24	164.66	164.15	164.245	2030328.0
2018-01-17 10:30:00	QQQ	ETF	164.24	164.61	164.22	164.585	1359217.0
2018-01-17 11:00:00	QQQ	ETF	164.6	165.04	164.46	164.81	1882128.0
2018-01-17 11:30:00	QQQ	ETF	164.81	164.9	164.66	164.75	1403918.0
2018-01-17 12:00:00	QQQ	ETF	164.7446	164.95	164.74	164.89	981824.0
2018-01-17 12:30:00	QQQ	ETF	164.8869	165.26	164.86	165.25	1939865.0

> showing 50 of 16,960 rows — these rows as CSV

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