PREVIEW / etf_30min / 2018-11-21

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-11-21.parquet
  size:    485 KB
  rows:    16,711

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-21 04:00:00	SPY	ETF	265.53	265.8	265.46	265.6	20305.0
2018-11-21 04:30:00	SPY	ETF	265.55	265.59	265.21	265.41	12715.0
2018-11-21 05:00:00	SPY	ETF	265.31	265.89	265.16	265.29	118556.0
2018-11-21 05:30:00	SPY	ETF	265.39	265.44	264.87	265.09	35841.0
2018-11-21 06:00:00	SPY	ETF	265.09	265.55	264.84	265.43	51053.0
2018-11-21 06:30:00	SPY	ETF	265.5	265.7	265.11	265.34	109294.0
2018-11-21 07:00:00	SPY	ETF	265.31	265.89	265.31	265.81	201691.0
2018-11-21 07:30:00	SPY	ETF	265.82	266.55	265.57	266.38	454400.0
2018-11-21 08:00:00	SPY	ETF	266.34	266.67	264.93	266.28	399110.0
2018-11-21 08:30:00	SPY	ETF	266.29	266.29	265.82	265.93	313784.0
2018-11-21 09:00:00	SPY	ETF	265.91	266.14	265.73	265.82	409370.0
2018-11-21 09:30:00	SPY	ETF	265.86	266.29	265.12	266.1	8898676.0
2018-11-21 10:00:00	SPY	ETF	266.11	266.65	265.65	266.49	5863214.0
2018-11-21 10:30:00	SPY	ETF	266.49	266.58	265.65	266.17	4711889.0
2018-11-21 11:00:00	SPY	ETF	266.175	267.15	265.91	266.79	6198273.0
2018-11-21 11:30:00	SPY	ETF	266.8	267.13	266.58	266.77	4354587.0
2018-11-21 12:00:00	SPY	ETF	266.79	266.89	266.26	266.48	2875894.0
2018-11-21 12:30:00	SPY	ETF	266.48	266.85	266.28	266.85	1834327.0
2018-11-21 13:00:00	SPY	ETF	266.85	266.93	266.34	266.555	2292946.0
2018-11-21 13:30:00	SPY	ETF	266.55	266.82	266.45	266.59	1903989.0
2018-11-21 14:00:00	SPY	ETF	266.59	266.71	266.3	266.59	1875145.0
2018-11-21 14:30:00	SPY	ETF	266.6	266.7	266.18	266.2515	3428611.0
2018-11-21 15:00:00	SPY	ETF	266.25	266.71	265.89	265.91	5876200.0
2018-11-21 15:30:00	SPY	ETF	265.91	265.91	265.01	265.07	12579766.0
2018-11-21 16:00:00	SPY	ETF	265.07	266.2609	264.8	264.98	7245451.0
2018-11-21 16:30:00	SPY	ETF	264.96	265.03	264.82	264.94	217503.0
2018-11-21 17:00:00	SPY	ETF	265.0	265.04	264.91	264.91	63272.0
2018-11-21 17:30:00	SPY	ETF	264.93	265.03	264.86	265.03	59621.0
2018-11-21 18:00:00	SPY	ETF	265.0	265.39	264.94	265.33	1609657.0
2018-11-21 18:30:00	SPY	ETF	265.33	265.33	265.1	265.27	17363.0
2018-11-21 19:00:00	SPY	ETF	265.23	265.3	265.19	265.22	5845.0
2018-11-21 19:30:00	SPY	ETF	265.25	265.35	265.25	265.35	20504.0
2018-11-21 04:00:00	QQQ	ETF	160.7	160.9	160.49	160.58	16738.0
2018-11-21 04:30:00	QQQ	ETF	160.53	160.53	160.29	160.52	6353.0
2018-11-21 05:00:00	QQQ	ETF	160.34	160.8	160.23	160.37	15147.0
2018-11-21 05:30:00	QQQ	ETF	160.37	160.48	159.95	160.2	15169.0
2018-11-21 06:00:00	QQQ	ETF	160.16	160.64	160.0	160.46	15609.0
2018-11-21 06:30:00	QQQ	ETF	160.46	160.67	160.04	160.2	60438.0
2018-11-21 07:00:00	QQQ	ETF	160.14	160.63	160.14	160.56	267842.0
2018-11-21 07:30:00	QQQ	ETF	160.58	161.33	160.51	161.14	364185.0
2018-11-21 08:00:00	QQQ	ETF	161.11	161.34	159.92	161.22	381813.0
2018-11-21 08:30:00	QQQ	ETF	161.18	161.2	160.74	161.01	435173.0
2018-11-21 09:00:00	QQQ	ETF	160.97	161.32	160.91	161.27	203461.0
2018-11-21 09:30:00	QQQ	ETF	161.29	161.9	160.11	161.19	6898490.0
2018-11-21 10:00:00	QQQ	ETF	161.18	161.77	160.59	161.37	4590532.0
2018-11-21 10:30:00	QQQ	ETF	161.355	161.505	160.625	161.11	2930001.0
2018-11-21 11:00:00	QQQ	ETF	161.12	161.97	160.8515	161.66	2393120.0
2018-11-21 11:30:00	QQQ	ETF	161.69	161.85	161.28	161.35	1963128.0
2018-11-21 12:00:00	QQQ	ETF	161.37	161.47	161.05	161.24	1733075.0
2018-11-21 12:30:00	QQQ	ETF	161.25	161.69	161.08	161.6411	1298558.0

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

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