PREVIEW / etf_30min / 2020-06-11

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-11.parquet
  size:    615 KB
  rows:    23,308

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-06-11 04:00:00	SPY	ETF	313.45	313.8	312.8	313.3	118404.0
2020-06-11 04:30:00	SPY	ETF	313.32	313.87	312.34	312.85	112052.0
2020-06-11 05:00:00	SPY	ETF	312.79	314.17	312.6	313.97	107961.0
2020-06-11 05:30:00	SPY	ETF	314.08	314.83	314.0	314.58	99344.0
2020-06-11 06:00:00	SPY	ETF	314.7	314.75	313.89	313.9	62089.0
2020-06-11 06:30:00	SPY	ETF	313.96	314.1	313.2	313.3	140212.0
2020-06-11 07:00:00	SPY	ETF	313.4	313.69	311.95	312.82	575624.0
2020-06-11 07:30:00	SPY	ETF	312.79	312.91	311.77	312.411	462012.0
2020-06-11 08:00:00	SPY	ETF	318.2822	318.2822	310.5	311.2201	1613576.0
2020-06-11 08:30:00	SPY	ETF	311.19	311.28	310.17	310.82	1215837.0
2020-06-11 09:00:00	SPY	ETF	310.87	312.03	310.4	311.44	1706524.0
2020-06-11 09:30:00	SPY	ETF	311.46	312.15	310.01	311.65	19644801.0
2020-06-11 10:00:00	SPY	ETF	311.66	311.96	310.16	310.1799	8874934.0
2020-06-11 10:30:00	SPY	ETF	310.175	311.2	308.92	309.1	7904459.0
2020-06-11 11:00:00	SPY	ETF	309.08	309.56	308.36	308.79	9406730.0
2020-06-11 11:30:00	SPY	ETF	308.8	309.01	307.16	308.01	9000928.0
2020-06-11 12:00:00	SPY	ETF	308.0	308.02	304.92	305.355	11709222.0
2020-06-11 12:30:00	SPY	ETF	305.35	306.695	303.75	304.23	13508466.0
2020-06-11 13:00:00	SPY	ETF	304.22	305.87	303.93	304.88	10440936.0
2020-06-11 13:30:00	SPY	ETF	304.89	305.38	303.77	304.72	7009169.0
2020-06-11 14:00:00	SPY	ETF	304.71	304.77	302.99	303.95	10488790.0
2020-06-11 14:30:00	SPY	ETF	303.95	304.08	301.0641	301.77	16237376.0
2020-06-11 15:00:00	SPY	ETF	301.7899	302.9	300.25	300.71	18901703.0
2020-06-11 15:30:00	SPY	ETF	300.69	302.58	300.01	300.62	39501425.0
2020-06-11 16:00:00	SPY	ETF	300.61	319.1184	300.38	301.27	16392825.0
2020-06-11 16:30:00	SPY	ETF	301.27	302.09	300.51	301.77	904461.0
2020-06-11 17:00:00	SPY	ETF	301.75	302.16	300.61	301.94	636169.0
2020-06-11 17:30:00	SPY	ETF	301.92	302.0	300.61	301.69	140853.0
2020-06-11 18:00:00	SPY	ETF	301.6	302.1	300.71	301.02	244536.0
2020-06-11 18:30:00	SPY	ETF	301.02	302.85	301.02	302.85	206748.0
2020-06-11 19:00:00	SPY	ETF	302.77	303.04	302.01	302.5	177773.0
2020-06-11 19:30:00	SPY	ETF	302.52	303.5	302.5	303.08	326713.0
2020-06-11 04:00:00	QQQ	ETF	243.01	243.49	242.9	243.37	59094.0
2020-06-11 04:30:00	QQQ	ETF	243.15	243.52	242.25	242.33	24944.0
2020-06-11 05:00:00	QQQ	ETF	242.39	243.31	242.38	243.27	16654.0
2020-06-11 05:30:00	QQQ	ETF	243.26	243.75	243.25	243.7	37123.0
2020-06-11 06:00:00	QQQ	ETF	243.82	243.82	243.23	243.23	38331.0
2020-06-11 06:30:00	QQQ	ETF	243.19	243.22	242.72	242.73	141265.0
2020-06-11 07:00:00	QQQ	ETF	242.86	243.12	242.09	242.5	180909.0
2020-06-11 07:30:00	QQQ	ETF	242.5	242.82	242.22	242.64	222497.0
2020-06-11 08:00:00	QQQ	ETF	242.8	244.97	241.7	242.04	423486.0
2020-06-11 08:30:00	QQQ	ETF	242.04	242.48	241.52	242.44	560587.0
2020-06-11 09:00:00	QQQ	ETF	242.44	242.7	242.13	242.28	592366.0
2020-06-11 09:30:00	QQQ	ETF	242.26	242.93	241.04	242.47	7260964.0
2020-06-11 10:00:00	QQQ	ETF	242.48	243.33	241.92	242.4	3217816.0
2020-06-11 10:30:00	QQQ	ETF	242.38	243.59	241.3	241.48	3679662.0
2020-06-11 11:00:00	QQQ	ETF	241.49	242.15	240.87	241.62	3020633.0
2020-06-11 11:30:00	QQQ	ETF	241.62	241.71	240.35	240.99	3024066.0
2020-06-11 12:00:00	QQQ	ETF	240.97	240.99	238.22	238.63	3885974.0
2020-06-11 12:30:00	QQQ	ETF	238.59	239.51	236.83	236.93	4043836.0

> showing 50 of 23,308 rows — these rows as CSV

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