PREVIEW / etf_30min / 2018-02-22

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-02-22.parquet
  size:    471 KB
  rows:    16,156

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-02-22 04:00:00	SPY	ETF	269.3	269.3	269.08	269.17	3585.0
2018-02-22 04:30:00	SPY	ETF	269.2	269.51	269.11	269.51	35329.0
2018-02-22 05:00:00	SPY	ETF	269.53	269.92	269.53	269.92	32732.0
2018-02-22 05:30:00	SPY	ETF	269.94	270.4	269.94	270.15	45622.0
2018-02-22 06:00:00	SPY	ETF	270.07	270.47	269.92	270.47	72613.0
2018-02-22 06:30:00	SPY	ETF	270.51	270.58	270.05	270.17	65268.0
2018-02-22 07:00:00	SPY	ETF	270.18	270.83	270.18	270.8	211237.0
2018-02-22 07:30:00	SPY	ETF	270.78	270.94	270.46	270.51	97383.0
2018-02-22 08:00:00	SPY	ETF	270.3	270.87	268.82	270.4	473292.0
2018-02-22 08:30:00	SPY	ETF	270.4	271.07	270.4	270.9	752153.0
2018-02-22 09:00:00	SPY	ETF	270.93	271.23	270.93	271.09	455906.0
2018-02-22 09:30:00	SPY	ETF	271.1	272.27	270.76	271.23	7861861.0
2018-02-22 10:00:00	SPY	ETF	271.25	271.93	270.82	271.67	5501219.0
2018-02-22 10:30:00	SPY	ETF	271.67	272.3385	271.42	271.74	4349835.0
2018-02-22 11:00:00	SPY	ETF	271.74	272.76	271.68	272.58	6299396.0
2018-02-22 11:30:00	SPY	ETF	272.58	272.97	272.11	272.785	2980045.0
2018-02-22 12:00:00	SPY	ETF	272.79	273.05	272.5	272.55	2708648.0
2018-02-22 12:30:00	SPY	ETF	272.56	272.64	271.505	271.76	10763762.0
2018-02-22 13:00:00	SPY	ETF	271.75	272.19	271.13	271.57	5953894.0
2018-02-22 13:30:00	SPY	ETF	271.56	271.63	270.58	271.2	3876687.0
2018-02-22 14:00:00	SPY	ETF	271.2	271.84	271.1	271.7955	3314423.0
2018-02-22 14:30:00	SPY	ETF	271.81	271.94	270.24	270.33	5071810.0
2018-02-22 15:00:00	SPY	ETF	270.32	271.07	270.01	270.61	7808459.0
2018-02-22 15:30:00	SPY	ETF	270.61	270.95	269.64	270.32	18371521.0
2018-02-22 16:00:00	SPY	ETF	270.32	271.18	270.19	270.98	6417891.0
2018-02-22 16:30:00	SPY	ETF	270.98	271.8026	270.2993	271.29	573143.0
2018-02-22 17:00:00	SPY	ETF	271.29	271.3	271.13	271.19	1867739.0
2018-02-22 17:30:00	SPY	ETF	271.17	271.23	271.15	271.16	25531.0
2018-02-22 18:00:00	SPY	ETF	271.19	271.3	270.4	271.05	1898370.0
2018-02-22 18:30:00	SPY	ETF	271.07	271.32	271.07	271.3	13816.0
2018-02-22 19:00:00	SPY	ETF	271.23	271.31	271.0	271.02	26767.0
2018-02-22 19:30:00	SPY	ETF	271.02	271.84	270.99	271.75	65391.0
2018-02-22 04:00:00	QQQ	ETF	163.88	163.9	163.67	163.88	3293.0
2018-02-22 04:30:00	QQQ	ETF	163.83	164.05	163.7	164.05	13549.0
2018-02-22 05:00:00	QQQ	ETF	164.1	164.37	164.06	164.36	12879.0
2018-02-22 05:30:00	QQQ	ETF	164.44	164.67	164.43	164.5	31392.0
2018-02-22 06:00:00	QQQ	ETF	164.49	164.8	164.43	164.78	19029.0
2018-02-22 06:30:00	QQQ	ETF	164.76	164.9	164.57	164.68	56873.0
2018-02-22 07:00:00	QQQ	ETF	164.65	165.13	164.65	165.13	129852.0
2018-02-22 07:30:00	QQQ	ETF	165.1	165.26	165.01	165.06	92464.0
2018-02-22 08:00:00	QQQ	ETF	164.82	165.24	163.99	165.1	144073.0
2018-02-22 08:30:00	QQQ	ETF	165.08	165.52	165.06	165.48	125066.0
2018-02-22 09:00:00	QQQ	ETF	165.5	165.68	165.4	165.51	227983.0
2018-02-22 09:30:00	QQQ	ETF	165.54	166.17	165.23	165.48	3477728.0
2018-02-22 10:00:00	QQQ	ETF	165.49	166.12	165.2	165.99	2474203.0
2018-02-22 10:30:00	QQQ	ETF	166.0	166.35	165.81	165.89	1732254.0
2018-02-22 11:00:00	QQQ	ETF	165.89	166.31	165.85	166.22	1294836.0
2018-02-22 11:30:00	QQQ	ETF	166.22	166.42	165.81	166.22	1333948.0
2018-02-22 12:00:00	QQQ	ETF	166.21	166.38	165.9401	166.0	899647.0
2018-02-22 12:30:00	QQQ	ETF	166.0	166.05	165.16	165.4	1872119.0

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

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