PREVIEW / etf_30min / 2020-08-10

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-08-10.parquet
  size:    560 KB
  rows:    20,607

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
2020-08-10 04:00:00	SPY	ETF	335.06	335.14	334.47	334.66	12082.0
2020-08-10 04:30:00	SPY	ETF	334.64	335.03	334.43	335.03	24699.0
2020-08-10 05:00:00	SPY	ETF	335.05	335.29	334.94	335.24	10614.0
2020-08-10 05:30:00	SPY	ETF	335.09	335.22	334.97	335.16	5430.0
2020-08-10 06:00:00	SPY	ETF	335.07	335.07	334.95	335.05	6634.0
2020-08-10 06:30:00	SPY	ETF	335.09	335.25	334.97	335.05	37425.0
2020-08-10 07:00:00	SPY	ETF	335.01	335.03	334.65	334.72	30082.0
2020-08-10 07:30:00	SPY	ETF	334.73	334.87	334.62	334.84	80394.0
2020-08-10 08:00:00	SPY	ETF	334.86	335.15	334.62	334.79	98619.0
2020-08-10 08:30:00	SPY	ETF	334.8	335.07	334.72	334.97	63249.0
2020-08-10 09:00:00	SPY	ETF	334.96	335.11	334.68	335.05	165857.0
2020-08-10 09:30:00	SPY	ETF	335.06	335.59	334.97	335.11	4306707.0
2020-08-10 10:00:00	SPY	ETF	335.12	335.38	334.7	335.34	2767380.0
2020-08-10 10:30:00	SPY	ETF	335.33	335.395	333.175	333.1999	3785418.0
2020-08-10 11:00:00	SPY	ETF	333.19	334.43	332.955	334.36	2705506.0
2020-08-10 11:30:00	SPY	ETF	334.36	335.02	334.23	334.9175	2396602.0
2020-08-10 12:00:00	SPY	ETF	334.92	335.025	334.4	334.4298	1387862.0
2020-08-10 12:30:00	SPY	ETF	334.42	335.28	334.34	335.14	1729192.0
2020-08-10 13:00:00	SPY	ETF	335.15	335.44	335.005	335.225	1837118.0
2020-08-10 13:30:00	SPY	ETF	335.24	335.36	334.91	335.09	1469715.0
2020-08-10 14:00:00	SPY	ETF	335.1	335.44	334.94	335.27	2734018.0
2020-08-10 14:30:00	SPY	ETF	335.27	335.505	334.79	335.481	1787439.0
2020-08-10 15:00:00	SPY	ETF	335.48	335.77	335.16	335.3	3790633.0
2020-08-10 15:30:00	SPY	ETF	335.2918	335.63	334.88	335.55	7538289.0
2020-08-10 16:00:00	SPY	ETF	335.57	335.6	335.0067	335.57	3562910.0
2020-08-10 16:30:00	SPY	ETF	335.31	335.57	335.28	335.33	558179.0
2020-08-10 17:00:00	SPY	ETF	335.3	335.57	335.28	335.42	93148.0
2020-08-10 17:30:00	SPY	ETF	335.41	335.44	335.03	335.1	165125.0
2020-08-10 18:00:00	SPY	ETF	335.11	336.82	335.06	335.21	115512.0
2020-08-10 18:30:00	SPY	ETF	335.16	335.24	334.89	334.95	60442.0
2020-08-10 19:00:00	SPY	ETF	334.97	335.02	334.85	334.96	76895.0
2020-08-10 19:30:00	SPY	ETF	334.91	335.41	334.91	335.34	170015.0
2020-08-10 20:00:00	SPY	ETF	335.31	335.31	335.27	335.27	400.0
2020-08-10 04:00:00	QQQ	ETF	271.36	271.39	270.9	270.9	8250.0
2020-08-10 04:30:00	QQQ	ETF	271.04	271.24	270.77	271.22	8268.0
2020-08-10 05:00:00	QQQ	ETF	271.12	271.4	271.12	271.32	8222.0
2020-08-10 05:30:00	QQQ	ETF	271.29	271.39	271.12	271.34	7558.0
2020-08-10 06:00:00	QQQ	ETF	271.25	271.33	271.23	271.32	12350.0
2020-08-10 06:30:00	QQQ	ETF	271.35	271.46	271.27	271.43	11870.0
2020-08-10 07:00:00	QQQ	ETF	271.4	271.43	271.12	271.35	47833.0
2020-08-10 07:30:00	QQQ	ETF	271.38	271.58	271.19	271.58	37954.0
2020-08-10 08:00:00	QQQ	ETF	271.3099	271.69	271.18	271.58	140300.0
2020-08-10 08:30:00	QQQ	ETF	271.6	271.8	271.5	271.67	97513.0
2020-08-10 09:00:00	QQQ	ETF	271.67	271.8	271.41	271.77	103714.0
2020-08-10 09:30:00	QQQ	ETF	271.74	271.98	269.98	270.35	4127057.0
2020-08-10 10:00:00	QQQ	ETF	270.38	270.51	269.5	269.91	3219895.0
2020-08-10 10:30:00	QQQ	ETF	269.91	269.9456	267.021	267.06	4031506.0
2020-08-10 11:00:00	QQQ	ETF	267.04	268.75	266.67	268.65	3258654.0
2020-08-10 11:30:00	QQQ	ETF	268.67	269.345	268.12	269.15	2081768.0
2020-08-10 12:00:00	QQQ	ETF	269.165	269.43	268.65	268.67	1291139.0

> showing 50 of 20,607 rows — these rows as CSV

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