PREVIEW / etf_30min / 2020-10-15

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-10-15.parquet
  size:    567 KB
  rows:    20,549

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-10-15 04:00:00	SPY	ETF	346.34	346.34	345.34	345.5	38460.0
2020-10-15 04:30:00	SPY	ETF	345.42	345.42	344.15	344.43	63829.0
2020-10-15 05:00:00	SPY	ETF	344.33	344.58	343.94	344.28	77611.0
2020-10-15 05:30:00	SPY	ETF	344.29	344.29	343.39	344.27	51882.0
2020-10-15 06:00:00	SPY	ETF	344.2	344.7	343.77	344.36	92582.0
2020-10-15 06:30:00	SPY	ETF	344.4	344.78	344.29	344.66	126539.0
2020-10-15 07:00:00	SPY	ETF	344.7	345.05	344.21	344.83	164030.0
2020-10-15 07:30:00	SPY	ETF	344.84	345.02	344.17	344.4	183241.0
2020-10-15 08:00:00	SPY	ETF	344.37	347.3	343.76	344.26	320759.0
2020-10-15 08:30:00	SPY	ETF	344.07	344.22	343.4	343.85	798394.0
2020-10-15 09:00:00	SPY	ETF	343.83	344.31	343.63	343.64	265201.0
2020-10-15 09:30:00	SPY	ETF	343.71	345.65	343.13	345.65	7293867.0
2020-10-15 10:00:00	SPY	ETF	345.64	345.69	344.5	344.67	4340596.0
2020-10-15 10:30:00	SPY	ETF	344.675	344.88	343.84	344.75	4120562.0
2020-10-15 11:00:00	SPY	ETF	344.74	346.05	344.0	345.4168	3087633.0
2020-10-15 11:30:00	SPY	ETF	345.41	346.36	345.3	345.57	4774652.0
2020-10-15 12:00:00	SPY	ETF	345.57	345.91	345.15	345.25	2297526.0
2020-10-15 12:30:00	SPY	ETF	345.25	345.92	344.84	345.87	2830753.0
2020-10-15 13:00:00	SPY	ETF	345.8699	346.38	345.77	346.05	1921264.0
2020-10-15 13:30:00	SPY	ETF	346.05	346.83	345.99	346.508	1846659.0
2020-10-15 14:00:00	SPY	ETF	346.52	347.008	346.515	346.885	2836188.0
2020-10-15 14:30:00	SPY	ETF	346.89	347.03	346.265	346.92	3132992.0
2020-10-15 15:00:00	SPY	ETF	346.91	347.73	346.78	347.6219	4467898.0
2020-10-15 15:30:00	SPY	ETF	347.63	348.02	347.09	347.51	10655711.0
2020-10-15 16:00:00	SPY	ETF	347.51	347.69	347.38	347.45	3348995.0
2020-10-15 16:30:00	SPY	ETF	347.45	347.75	347.45	347.53	199279.0
2020-10-15 17:00:00	SPY	ETF	347.52	347.61	347.5	347.6	40320.0
2020-10-15 17:30:00	SPY	ETF	347.6	347.79	347.59	347.76	84736.0
2020-10-15 18:00:00	SPY	ETF	347.82	347.92	347.69	347.73	54467.0
2020-10-15 18:30:00	SPY	ETF	347.7201	347.7201	347.6	347.6	43334.0
2020-10-15 19:00:00	SPY	ETF	347.61	348.5	347.56	348.48	51516.0
2020-10-15 19:30:00	SPY	ETF	348.48	348.61	348.25	348.3	96384.0
2020-10-15 04:00:00	QQQ	ETF	289.49	289.49	287.83	288.02	85288.0
2020-10-15 04:30:00	QQQ	ETF	288.05	288.05	286.63	287.24	62302.0
2020-10-15 05:00:00	QQQ	ETF	287.15	287.22	286.69	287.03	167239.0
2020-10-15 05:30:00	QQQ	ETF	286.96	287.09	286.22	287.02	84570.0
2020-10-15 06:00:00	QQQ	ETF	287.2	287.64	287.0	287.5	71830.0
2020-10-15 06:30:00	QQQ	ETF	287.56	288.33	287.4	288.11	201314.0
2020-10-15 07:00:00	QQQ	ETF	288.09	288.43	287.58	288.13	174679.0
2020-10-15 07:30:00	QQQ	ETF	288.15	288.32	287.57	287.8	210328.0
2020-10-15 08:00:00	QQQ	ETF	287.85	290.36	287.22	288.02	226179.0
2020-10-15 08:30:00	QQQ	ETF	287.91	288.03	287.01	287.74	299569.0
2020-10-15 09:00:00	QQQ	ETF	287.64	287.9	287.15	287.15	240055.0
2020-10-15 09:30:00	QQQ	ETF	287.24	289.75	286.68	289.58	4688275.0
2020-10-15 10:00:00	QQQ	ETF	289.567	289.59	287.59	287.68	3536626.0
2020-10-15 10:30:00	QQQ	ETF	287.665	288.1	286.54	287.94	3185558.0
2020-10-15 11:00:00	QQQ	ETF	287.9305	289.02	286.94	288.32	2679766.0
2020-10-15 11:30:00	QQQ	ETF	288.32	289.16	288.13	288.28	1833263.0
2020-10-15 12:00:00	QQQ	ETF	288.2935	288.8	287.45	287.6	2001045.0
2020-10-15 12:30:00	QQQ	ETF	287.6	288.2199	287.15	288.0299	1620521.0

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

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