PREVIEW / etf_30min / 2020-07-21

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-21.parquet
  size:    563 KB
  rows:    21,032

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-07-21 04:00:00	SPY	ETF	326.0	326.75	326.0	326.74	14491.0
2020-07-21 04:30:00	SPY	ETF	326.77	326.92	326.76	326.8	15704.0
2020-07-21 05:00:00	SPY	ETF	326.85	326.89	326.7	326.75	10112.0
2020-07-21 05:30:00	SPY	ETF	326.71	326.99	326.71	326.82	25852.0
2020-07-21 06:00:00	SPY	ETF	326.83	326.89	326.76	326.82	6726.0
2020-07-21 06:30:00	SPY	ETF	326.83	327.17	326.77	326.9	45195.0
2020-07-21 07:00:00	SPY	ETF	326.78	327.01	326.56	327.0	159056.0
2020-07-21 07:30:00	SPY	ETF	327.07	327.33	326.77	327.01	122408.0
2020-07-21 08:00:00	SPY	ETF	326.7199	327.32	325.05	326.89	144277.0
2020-07-21 08:30:00	SPY	ETF	326.9	326.95	326.65	326.7	127538.0
2020-07-21 09:00:00	SPY	ETF	326.67	326.81	326.38	326.46	166957.0
2020-07-21 09:30:00	SPY	ETF	326.45	326.93	325.89	326.71	7420847.0
2020-07-21 10:00:00	SPY	ETF	326.73	326.91	325.48	325.76	4466247.0
2020-07-21 10:30:00	SPY	ETF	325.77	326.66	325.44	326.4	3908527.0
2020-07-21 11:00:00	SPY	ETF	326.4	326.6501	325.68	326.43	2605762.0
2020-07-21 11:30:00	SPY	ETF	326.43	326.6738	325.62	326.01	2369454.0
2020-07-21 12:00:00	SPY	ETF	326.02	326.15	325.59	326.05	2111744.0
2020-07-21 12:30:00	SPY	ETF	326.04	326.3	325.76	326.29	1760256.0
2020-07-21 13:00:00	SPY	ETF	326.2883	326.37	325.77	326.31	1568468.0
2020-07-21 13:30:00	SPY	ETF	326.305	326.69	326.24	326.52	1519889.0
2020-07-21 14:00:00	SPY	ETF	326.53	326.85	326.34	326.61	1687998.0
2020-07-21 14:30:00	SPY	ETF	326.61	326.62	326.26	326.42	1627528.0
2020-07-21 15:00:00	SPY	ETF	326.43	326.505	324.87	325.0203	4756392.0
2020-07-21 15:30:00	SPY	ETF	325.04	325.405	323.94	324.96	13429725.0
2020-07-21 16:00:00	SPY	ETF	324.95	325.34	324.85	325.15	6273014.0
2020-07-21 16:30:00	SPY	ETF	325.17	325.29	324.95	325.02	239872.0
2020-07-21 17:00:00	SPY	ETF	325.01	325.09	324.8	324.85	125301.0
2020-07-21 17:30:00	SPY	ETF	324.86	324.97	324.85	324.95	26546.0
2020-07-21 18:00:00	SPY	ETF	324.96	325.36	324.91	325.2	128122.0
2020-07-21 18:30:00	SPY	ETF	325.21	325.85	325.21	325.77	87067.0
2020-07-21 19:00:00	SPY	ETF	325.7	325.75	325.41	325.51	28635.0
2020-07-21 19:30:00	SPY	ETF	325.53	325.84	325.48	325.69	39780.0
2020-07-21 04:00:00	QQQ	ETF	269.14	269.76	269.14	269.65	21139.0
2020-07-21 04:30:00	QQQ	ETF	269.57	269.66	269.4	269.41	34137.0
2020-07-21 05:00:00	QQQ	ETF	269.42	269.46	269.19	269.21	33905.0
2020-07-21 05:30:00	QQQ	ETF	269.34	269.69	269.32	269.5	8120.0
2020-07-21 06:00:00	QQQ	ETF	269.51	269.58	269.31	269.38	34276.0
2020-07-21 06:30:00	QQQ	ETF	269.44	269.72	269.16	269.24	40285.0
2020-07-21 07:00:00	QQQ	ETF	269.2	269.34	268.91	269.33	127079.0
2020-07-21 07:30:00	QQQ	ETF	269.32	269.56	269.14	269.35	92727.0
2020-07-21 08:00:00	QQQ	ETF	269.2801	269.78	268.54	269.11	114583.0
2020-07-21 08:30:00	QQQ	ETF	269.16	269.25	268.8	268.82	145914.0
2020-07-21 09:00:00	QQQ	ETF	268.82	269.18	268.03	268.42	512702.0
2020-07-21 09:30:00	QQQ	ETF	268.41	268.41	266.0514	267.0	7451144.0
2020-07-21 10:00:00	QQQ	ETF	266.99	267.23	265.51	265.92	4056151.0
2020-07-21 10:30:00	QQQ	ETF	265.94	266.3	264.97	265.892	2869119.0
2020-07-21 11:00:00	QQQ	ETF	265.88	266.22	264.75	265.47	2010749.0
2020-07-21 11:30:00	QQQ	ETF	265.48	265.82	264.24	264.67	1881807.0
2020-07-21 12:00:00	QQQ	ETF	264.6714	265.01	264.18	264.8999	1693503.0
2020-07-21 12:30:00	QQQ	ETF	264.87	265.17	264.4	265.15	1498820.0

> showing 50 of 21,032 rows — these rows as CSV

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