PREVIEW / etf_30min / 2018-11-08

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-08.parquet
  size:    496 KB
  rows:    17,064

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-11-08 04:00:00	SPY	ETF	280.99	281.0	280.8	280.8	17536.0
2018-11-08 04:30:00	SPY	ETF	280.8	280.83	280.22	280.25	36876.0
2018-11-08 05:00:00	SPY	ETF	280.21	280.27	280.01	280.18	59212.0
2018-11-08 05:30:00	SPY	ETF	280.11	280.12	279.9	279.97	61696.0
2018-11-08 06:00:00	SPY	ETF	279.93	280.28	279.92	280.15	22018.0
2018-11-08 06:30:00	SPY	ETF	280.15	280.15	279.86	280.15	37092.0
2018-11-08 07:00:00	SPY	ETF	280.2	280.46	280.15	280.25	114592.0
2018-11-08 07:30:00	SPY	ETF	280.29	280.55	280.29	280.5	194387.0
2018-11-08 08:00:00	SPY	ETF	280.3001	280.6	280.24	280.28	331936.0
2018-11-08 08:30:00	SPY	ETF	280.39	280.46	280.12	280.33	218263.0
2018-11-08 09:00:00	SPY	ETF	280.34	280.34	280.03	280.09	641652.0
2018-11-08 09:30:00	SPY	ETF	280.11	280.9898	280.0785	280.9	7731075.0
2018-11-08 10:00:00	SPY	ETF	280.9	281.0	280.14	280.3	4859941.0
2018-11-08 10:30:00	SPY	ETF	280.3	280.79	280.22	280.72	3764687.0
2018-11-08 11:00:00	SPY	ETF	280.72	280.95	280.41	280.68	2151377.0
2018-11-08 11:30:00	SPY	ETF	280.68	281.14	280.66	280.94	2429341.0
2018-11-08 12:00:00	SPY	ETF	280.94	281.22	280.82	280.87	2023753.0
2018-11-08 12:30:00	SPY	ETF	280.86	281.0699	280.6116	280.63	1833011.0
2018-11-08 13:00:00	SPY	ETF	280.6399	280.76	280.18	280.18	1767241.0
2018-11-08 13:30:00	SPY	ETF	280.17	280.5262	280.09	280.4975	3126469.0
2018-11-08 14:00:00	SPY	ETF	280.5	280.92	279.8	279.9736	5995721.0
2018-11-08 14:30:00	SPY	ETF	279.97	280.0576	279.22	279.84	5792912.0
2018-11-08 15:00:00	SPY	ETF	279.84	280.26	279.43	279.68	4366750.0
2018-11-08 15:30:00	SPY	ETF	279.69	280.44	279.34	280.44	9216551.0
2018-11-08 16:00:00	SPY	ETF	280.42	280.77	280.1941	280.59	5929759.0
2018-11-08 16:30:00	SPY	ETF	280.6	280.63	280.21	280.26	265809.0
2018-11-08 17:00:00	SPY	ETF	280.5	280.5	280.02	280.14	610199.0
2018-11-08 17:30:00	SPY	ETF	280.07	280.15	280.03	280.04	100434.0
2018-11-08 18:00:00	SPY	ETF	280.06	280.23	279.96	279.99	108826.0
2018-11-08 18:30:00	SPY	ETF	280.01	280.29	280.01	280.29	27903.0
2018-11-08 19:00:00	SPY	ETF	280.27	280.52	280.27	280.48	30909.0
2018-11-08 19:30:00	SPY	ETF	280.49	280.62	280.37	280.39	30794.0
2018-11-08 20:00:00	SPY	ETF	280.5	280.5	280.4137	280.4137	42000.0
2018-11-08 04:00:00	QQQ	ETF	175.66	175.66	175.34	175.34	8418.0
2018-11-08 04:30:00	QQQ	ETF	175.34	175.38	174.91	174.92	26580.0
2018-11-08 05:00:00	QQQ	ETF	174.8	174.81	174.51	174.51	39926.0
2018-11-08 05:30:00	QQQ	ETF	174.48	174.62	174.36	174.49	39173.0
2018-11-08 06:00:00	QQQ	ETF	174.47	174.79	174.47	174.66	32490.0
2018-11-08 06:30:00	QQQ	ETF	174.65	174.75	174.39	174.73	22272.0
2018-11-08 07:00:00	QQQ	ETF	174.72	175.02	174.68	174.85	98839.0
2018-11-08 07:30:00	QQQ	ETF	174.87	175.05	174.82	174.95	74219.0
2018-11-08 08:00:00	QQQ	ETF	174.9201	175.02	174.65	174.8	202228.0
2018-11-08 08:30:00	QQQ	ETF	174.86	174.92	174.63	174.77	148843.0
2018-11-08 09:00:00	QQQ	ETF	174.72	174.81	174.57	174.73	138263.0
2018-11-08 09:30:00	QQQ	ETF	174.76	175.21	174.11	175.13	5217806.0
2018-11-08 10:00:00	QQQ	ETF	175.13	175.302	174.41	174.64	3011276.0
2018-11-08 10:30:00	QQQ	ETF	174.65	175.1	174.42	174.81	2176771.0
2018-11-08 11:00:00	QQQ	ETF	174.82	175.08	174.35	174.7799	1750419.0
2018-11-08 11:30:00	QQQ	ETF	174.78	175.04	174.66	174.81	1062802.0
2018-11-08 12:00:00	QQQ	ETF	174.84	174.945	174.6239	174.7	912106.0

> showing 50 of 17,064 rows — these rows as CSV

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