PREVIEW / etf_30min / 2018-03-07

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-03-07.parquet
  size:    473 KB
  rows:    16,163

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-03-07 04:00:00	SPY	ETF	270.08	270.28	269.67	270.05	132924.0
2018-03-07 04:30:00	SPY	ETF	270.0	270.0	269.65	269.83	17495.0
2018-03-07 05:00:00	SPY	ETF	269.91	270.56	269.84	270.35	55404.0
2018-03-07 05:30:00	SPY	ETF	270.5	270.59	269.92	269.94	20186.0
2018-03-07 06:00:00	SPY	ETF	269.96	270.03	269.56	269.82	37867.0
2018-03-07 06:30:00	SPY	ETF	269.9	270.2	269.83	269.99	101756.0
2018-03-07 07:00:00	SPY	ETF	269.98	270.85	269.92	270.8	437732.0
2018-03-07 07:30:00	SPY	ETF	270.8	270.85	270.47	270.7	634485.0
2018-03-07 08:00:00	SPY	ETF	270.29	271.14	268.75	271.05	1033089.0
2018-03-07 08:30:00	SPY	ETF	271.03	271.09	270.54	270.7	414014.0
2018-03-07 09:00:00	SPY	ETF	270.73	270.78	270.22	270.4	569436.0
2018-03-07 09:30:00	SPY	ETF	270.42	271.84	270.2	271.13	10218938.0
2018-03-07 10:00:00	SPY	ETF	271.11	272.01	271.04	271.8602	5876736.0
2018-03-07 10:30:00	SPY	ETF	271.84	272.51	271.67	272.31	4776825.0
2018-03-07 11:00:00	SPY	ETF	272.3	272.39	271.33	271.69	3925756.0
2018-03-07 11:30:00	SPY	ETF	271.68	272.06	270.86	270.88	4328218.0
2018-03-07 12:00:00	SPY	ETF	270.89	271.09	270.27	270.75	5506038.0
2018-03-07 12:30:00	SPY	ETF	270.7583	271.19	270.55	271.08	4858972.0
2018-03-07 13:00:00	SPY	ETF	271.07	271.44	270.32	271.42	3745172.0
2018-03-07 13:30:00	SPY	ETF	271.41	271.62	271.14	271.38	2558321.0
2018-03-07 14:00:00	SPY	ETF	271.39	271.895	271.12	271.503	5276334.0
2018-03-07 14:30:00	SPY	ETF	271.51	272.22	271.51	271.809	3905698.0
2018-03-07 15:00:00	SPY	ETF	271.8	272.7	271.73	272.56	5775868.0
2018-03-07 15:30:00	SPY	ETF	272.57	273.18	272.54	272.8	13004625.0
2018-03-07 16:00:00	SPY	ETF	272.79	272.85	272.37	272.44	7887275.0
2018-03-07 16:30:00	SPY	ETF	272.47	272.53	270.7417	272.4	400717.0
2018-03-07 17:00:00	SPY	ETF	272.48	272.7912	272.43	272.55	444050.0
2018-03-07 17:30:00	SPY	ETF	272.54	272.55	272.45	272.47	20344.0
2018-03-07 18:00:00	SPY	ETF	272.47	272.48	272.2	272.32	53246.0
2018-03-07 18:30:00	SPY	ETF	272.34	272.48	272.32	272.44	11896.0
2018-03-07 19:00:00	SPY	ETF	272.4	272.58	272.2	272.24	25199.0
2018-03-07 19:30:00	SPY	ETF	272.28	272.32	272.2	272.27	41815.0
2018-03-07 04:00:00	QQQ	ETF	166.97	167.07	166.76	166.93	33324.0
2018-03-07 04:30:00	QQQ	ETF	166.94	166.94	166.66	166.8	10850.0
2018-03-07 05:00:00	QQQ	ETF	166.79	167.33	166.79	167.14	76184.0
2018-03-07 05:30:00	QQQ	ETF	167.19	167.27	166.94	167.02	25790.0
2018-03-07 06:00:00	QQQ	ETF	166.95	167.0	166.72	166.84	38225.0
2018-03-07 06:30:00	QQQ	ETF	166.92	167.03	166.85	166.98	18890.0
2018-03-07 07:00:00	QQQ	ETF	166.99	167.52	166.99	167.52	117260.0
2018-03-07 07:30:00	QQQ	ETF	167.47	167.47	167.28	167.32	101254.0
2018-03-07 08:00:00	QQQ	ETF	167.26	167.61	167.13	167.54	260702.0
2018-03-07 08:30:00	QQQ	ETF	167.5	167.6	167.32	167.37	135155.0
2018-03-07 09:00:00	QQQ	ETF	167.36	167.5	167.08	167.26	250111.0
2018-03-07 09:30:00	QQQ	ETF	167.26	168.13	167.1	167.59	3524152.0
2018-03-07 10:00:00	QQQ	ETF	167.5801	168.2099	167.4225	168.11	2133710.0
2018-03-07 10:30:00	QQQ	ETF	168.1	168.6	167.9	168.45	2172669.0
2018-03-07 11:00:00	QQQ	ETF	168.43	168.46	167.63	167.9751	1628502.0
2018-03-07 11:30:00	QQQ	ETF	167.97	168.189	167.415	167.42	1116846.0
2018-03-07 12:00:00	QQQ	ETF	167.415	167.54	166.96	167.46	2175070.0
2018-03-07 12:30:00	QQQ	ETF	167.4457	167.9	167.36	167.83	1033642.0

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

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