PREVIEW / etf_30min / 2018-01-08

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-08.parquet
  size:    483 KB
  rows:    16,790

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-08 04:00:00	SPY	ETF	273.55	273.6	273.52	273.55	2250.0
2018-01-08 04:30:00	SPY	ETF	273.54	273.56	273.48	273.56	5700.0
2018-01-08 05:00:00	SPY	ETF	273.57	273.57	273.52	273.52	400.0
2018-01-08 05:30:00	SPY	ETF	273.57	273.69	273.54	273.57	3838.0
2018-01-08 06:00:00	SPY	ETF	273.62	273.68	273.52	273.52	2000.0
2018-01-08 06:30:00	SPY	ETF	273.57	273.57	273.2	273.2	75492.0
2018-01-08 07:00:00	SPY	ETF	273.2	273.32	273.07	273.1	256022.0
2018-01-08 07:30:00	SPY	ETF	273.1	273.18	272.99	273.14	246895.0
2018-01-08 08:00:00	SPY	ETF	273.12	273.35	273.01	273.02	265191.0
2018-01-08 08:30:00	SPY	ETF	273.02	273.29	273.0	273.19	240846.0
2018-01-08 09:00:00	SPY	ETF	273.22	273.32	273.19	273.3	200174.0
2018-01-08 09:30:00	SPY	ETF	273.31	273.47	272.98	273.339	5386261.0
2018-01-08 10:00:00	SPY	ETF	273.34	273.43	273.1	273.37	2712227.0
2018-01-08 10:30:00	SPY	ETF	273.36	273.47	273.21	273.39	1680718.0
2018-01-08 11:00:00	SPY	ETF	273.38	273.57	273.3	273.51	1628972.0
2018-01-08 11:30:00	SPY	ETF	273.51	273.62	273.41	273.44	1496824.0
2018-01-08 12:00:00	SPY	ETF	273.45	273.64	273.43	273.59	1083064.0
2018-01-08 12:30:00	SPY	ETF	273.585	273.67	273.4929	273.645	1266972.0
2018-01-08 13:00:00	SPY	ETF	273.65	274.0	273.65	273.98	3755320.0
2018-01-08 13:30:00	SPY	ETF	273.98	273.995	273.88	273.95	1746181.0
2018-01-08 14:00:00	SPY	ETF	273.95	274.04	273.92	273.93	1623517.0
2018-01-08 14:30:00	SPY	ETF	273.93	274.04	273.87	274.02	1904820.0
2018-01-08 15:00:00	SPY	ETF	274.025	274.07	273.79	273.82	3153891.0
2018-01-08 15:30:00	SPY	ETF	273.825	274.1	273.77	273.93	10510811.0
2018-01-08 16:00:00	SPY	ETF	273.94	274.0007	273.85	273.98	7899816.0
2018-01-08 16:30:00	SPY	ETF	273.99	274.03	273.94	273.97	1432000.0
2018-01-08 17:00:00	SPY	ETF	273.97	274.0	273.5683	273.93	1079082.0
2018-01-08 17:30:00	SPY	ETF	273.95	273.95	273.85	273.88	170930.0
2018-01-08 18:00:00	SPY	ETF	273.91	274.05	273.9	274.02	52816.0
2018-01-08 18:30:00	SPY	ETF	274.02	274.05	273.94	274.04	10625.0
2018-01-08 19:00:00	SPY	ETF	274.02	274.02	273.92	273.93	11359.0
2018-01-08 19:30:00	SPY	ETF	273.93	274.02	273.93	273.96	10181.0
2018-01-08 04:00:00	QQQ	ETF	162.09	162.14	162.05	162.05	10000.0
2018-01-08 04:30:00	QQQ	ETF	162.06	162.06	162.06	162.06	3000.0
2018-01-08 05:00:00	QQQ	ETF	162.09	162.14	162.09	162.12	4700.0
2018-01-08 05:30:00	QQQ	ETF	162.12	162.12	162.08	162.12	4189.0
2018-01-08 06:00:00	QQQ	ETF	162.16	162.16	162.08	162.08	4811.0
2018-01-08 06:30:00	QQQ	ETF	162.09	162.09	162.0	162.0	2986.0
2018-01-08 07:00:00	QQQ	ETF	161.91	161.94	161.82	161.83	62745.0
2018-01-08 07:30:00	QQQ	ETF	161.85	161.89	161.76	161.87	26250.0
2018-01-08 08:00:00	QQQ	ETF	161.94	161.94	161.73	161.73	36210.0
2018-01-08 08:30:00	QQQ	ETF	161.73	161.86	161.73	161.81	95871.0
2018-01-08 09:00:00	QQQ	ETF	161.83	161.92	161.81	161.92	90762.0
2018-01-08 09:30:00	QQQ	ETF	161.9	162.26	161.86	162.17	2555095.0
2018-01-08 10:00:00	QQQ	ETF	162.17	162.36	161.88	162.345	1476698.0
2018-01-08 10:30:00	QQQ	ETF	162.35	162.425	162.17	162.35	1131671.0
2018-01-08 11:00:00	QQQ	ETF	162.345	162.54	162.285	162.48	1099775.0
2018-01-08 11:30:00	QQQ	ETF	162.48	162.62	162.425	162.45	863964.0
2018-01-08 12:00:00	QQQ	ETF	162.45	162.51	162.41	162.461	519516.0
2018-01-08 12:30:00	QQQ	ETF	162.4667	162.4667	162.34	162.41	480439.0

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

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