PREVIEW / etf_30min / 2018-06-28

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-06-28.parquet
  size:    468 KB
  rows:    16,180

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-06-28 04:00:00	SPY	ETF	270.3	270.82	270.28	270.54	21802.0
2018-06-28 04:30:00	SPY	ETF	270.51	270.51	269.94	270.16	29170.0
2018-06-28 05:00:00	SPY	ETF	270.19	270.19	270.02	270.09	12155.0
2018-06-28 05:30:00	SPY	ETF	269.99	270.06	269.59	270.06	26447.0
2018-06-28 06:00:00	SPY	ETF	269.99	270.24	269.99	270.23	22460.0
2018-06-28 06:30:00	SPY	ETF	270.27	270.69	270.15	270.17	99340.0
2018-06-28 07:00:00	SPY	ETF	270.18	270.23	269.83	269.86	112900.0
2018-06-28 07:30:00	SPY	ETF	269.83	270.03	269.6	269.85	75894.0
2018-06-28 08:00:00	SPY	ETF	269.77	270.56	268.51	268.8	1005133.0
2018-06-28 08:30:00	SPY	ETF	268.7	268.98	268.46	268.64	536001.0
2018-06-28 09:00:00	SPY	ETF	268.66	269.29	268.66	269.28	559833.0
2018-06-28 09:30:00	SPY	ETF	269.29	269.86	268.5772	269.44	10262266.0
2018-06-28 10:00:00	SPY	ETF	269.47	269.82	268.76	269.13	7493645.0
2018-06-28 10:30:00	SPY	ETF	269.14	269.98	268.49	269.93	6381696.0
2018-06-28 11:00:00	SPY	ETF	269.93	270.34	269.24	270.24	6109277.0
2018-06-28 11:30:00	SPY	ETF	270.24	270.5	269.81	270.13	4252627.0
2018-06-28 12:00:00	SPY	ETF	270.15	270.29	269.16	269.43	3048264.0
2018-06-28 12:30:00	SPY	ETF	269.43	270.07	269.225	269.95	2361385.0
2018-06-28 13:00:00	SPY	ETF	269.96	270.325	269.86	270.19	2342727.0
2018-06-28 13:30:00	SPY	ETF	270.185	270.49	270.03	270.41	2580887.0
2018-06-28 14:00:00	SPY	ETF	270.4	270.91	270.28	270.9	3897374.0
2018-06-28 14:30:00	SPY	ETF	270.89	271.42	270.7	271.39	4443826.0
2018-06-28 15:00:00	SPY	ETF	271.39	271.75	271.19	271.34	5260189.0
2018-06-28 15:30:00	SPY	ETF	271.34	271.38	270.77	270.95	9667148.0
2018-06-28 16:00:00	SPY	ETF	270.94	271.11	270.76	270.99	4044114.0
2018-06-28 16:30:00	SPY	ETF	271.01	271.24	270.88	271.19	245112.0
2018-06-28 17:00:00	SPY	ETF	271.19	271.26	271.16	271.19	94193.0
2018-06-28 17:30:00	SPY	ETF	271.24	271.3	271.17	271.2	50422.0
2018-06-28 18:00:00	SPY	ETF	271.2	271.34	271.13	271.19	49999.0
2018-06-28 18:30:00	SPY	ETF	271.19	271.19	270.98	271.01	26447.0
2018-06-28 19:00:00	SPY	ETF	270.98	271.16	270.97	271.16	6470.0
2018-06-28 19:30:00	SPY	ETF	271.17	271.28	271.05	271.25	5605.0
2018-06-28 04:00:00	QQQ	ETF	170.57	170.84	170.57	170.6	20400.0
2018-06-28 04:30:00	QQQ	ETF	170.57	170.57	170.1	170.32	14224.0
2018-06-28 05:00:00	QQQ	ETF	170.33	170.36	170.23	170.27	4440.0
2018-06-28 05:30:00	QQQ	ETF	170.15	170.25	169.92	170.25	41150.0
2018-06-28 06:00:00	QQQ	ETF	170.24	170.31	170.11	170.27	4870.0
2018-06-28 06:30:00	QQQ	ETF	170.32	170.63	170.28	170.28	27569.0
2018-06-28 07:00:00	QQQ	ETF	170.29	170.32	170.05	170.05	47648.0
2018-06-28 07:30:00	QQQ	ETF	170.06	170.18	169.87	170.09	151362.0
2018-06-28 08:00:00	QQQ	ETF	170.19	170.29	168.97	169.19	425326.0
2018-06-28 08:30:00	QQQ	ETF	169.12	169.29	168.87	169.09	341151.0
2018-06-28 09:00:00	QQQ	ETF	169.12	169.53	169.11	169.53	412494.0
2018-06-28 09:30:00	QQQ	ETF	169.52	170.5	169.25	170.17	6957859.0
2018-06-28 10:00:00	QQQ	ETF	170.24	170.41	169.5	169.71	4280306.0
2018-06-28 10:30:00	QQQ	ETF	169.72	170.55	169.17	170.53	4720708.0
2018-06-28 11:00:00	QQQ	ETF	170.53	170.78	170.051	170.67	3510063.0
2018-06-28 11:30:00	QQQ	ETF	170.65	170.92	170.38	170.62	1829311.0
2018-06-28 12:00:00	QQQ	ETF	170.63	170.73	169.85	170.04	1866200.0
2018-06-28 12:30:00	QQQ	ETF	170.04	170.49	169.84	170.39	1435110.0

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

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