PREVIEW / etf_30min / 2020-03-24

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-24.parquet
  size:    616 KB
  rows:    22,929

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-03-24 04:00:00	SPY	ETF	232.03	233.5	231.5	231.6	143430.0
2020-03-24 04:30:00	SPY	ETF	231.5	232.75	231.05	232.74	45715.0
2020-03-24 05:00:00	SPY	ETF	232.68	233.23	232.29	233.05	57869.0
2020-03-24 05:30:00	SPY	ETF	233.13	234.47	232.76	234.12	123337.0
2020-03-24 06:00:00	SPY	ETF	234.11	234.75	234.01	234.71	90509.0
2020-03-24 06:30:00	SPY	ETF	234.72	235.2	234.2	234.89	183270.0
2020-03-24 07:00:00	SPY	ETF	234.89	234.98	232.04	233.15	1027848.0
2020-03-24 07:30:00	SPY	ETF	233.16	233.67	231.77	232.79	557622.0
2020-03-24 08:00:00	SPY	ETF	232.79	235.09	228.03	231.62	1028215.0
2020-03-24 08:30:00	SPY	ETF	231.66	234.0	230.85	233.59	1535597.0
2020-03-24 09:00:00	SPY	ETF	233.59	235.0	232.56	234.15	1529209.0
2020-03-24 09:30:00	SPY	ETF	234.42	238.5	233.8	235.51	27941363.0
2020-03-24 10:00:00	SPY	ETF	235.4994	239.36	234.6	238.45	17436724.0
2020-03-24 10:30:00	SPY	ETF	238.47	239.1	237.04	237.46	13151927.0
2020-03-24 11:00:00	SPY	ETF	237.48	238.7	236.16	238.36	11518488.0
2020-03-24 11:30:00	SPY	ETF	238.37	240.46	237.58	240.43	12493793.0
2020-03-24 12:00:00	SPY	ETF	240.43	242.29	239.65	242.24	14171529.0
2020-03-24 12:30:00	SPY	ETF	242.23	242.96	239.57	239.65	12934499.0
2020-03-24 13:00:00	SPY	ETF	239.66	240.65	237.86	239.41	16056094.0
2020-03-24 13:30:00	SPY	ETF	239.41	240.2099	236.76	237.25	10721323.0
2020-03-24 14:00:00	SPY	ETF	237.24	239.491	235.05	237.38	16903591.0
2020-03-24 14:30:00	SPY	ETF	237.36	240.67	236.611	240.58	11464439.0
2020-03-24 15:00:00	SPY	ETF	240.56	241.87	240.21	241.4473	12087256.0
2020-03-24 15:30:00	SPY	ETF	241.44	244.1	240.41	243.59	34714223.0
2020-03-24 16:00:00	SPY	ETF	243.59	244.31	240.3109	243.38	9724717.0
2020-03-24 16:30:00	SPY	ETF	243.4	245.02	242.7	244.45	1558070.0
2020-03-24 17:00:00	SPY	ETF	244.42	244.74	243.14	243.27	1117549.0
2020-03-24 17:30:00	SPY	ETF	243.27	244.33	243.01	244.2	375885.0
2020-03-24 18:00:00	SPY	ETF	244.26	246.55	243.03	246.05	912200.0
2020-03-24 18:30:00	SPY	ETF	246.2	247.17	245.4	245.75	594113.0
2020-03-24 19:00:00	SPY	ETF	245.75	245.84	243.15	244.26	476186.0
2020-03-24 19:30:00	SPY	ETF	244.33	244.33	241.56	242.47	455300.0
2020-03-24 04:00:00	QQQ	ETF	177.48	178.6	177.23	177.33	113733.0
2020-03-24 04:30:00	QQQ	ETF	177.42	178.2	176.9	178.18	109349.0
2020-03-24 05:00:00	QQQ	ETF	178.2	178.45	177.91	178.32	63557.0
2020-03-24 05:30:00	QQQ	ETF	178.3	179.48	178.16	179.45	41840.0
2020-03-24 06:00:00	QQQ	ETF	179.48	180.04	179.42	179.8	78651.0
2020-03-24 06:30:00	QQQ	ETF	180.07	180.12	179.5	179.8	43344.0
2020-03-24 07:00:00	QQQ	ETF	179.82	179.89	177.02	177.97	301965.0
2020-03-24 07:30:00	QQQ	ETF	177.97	178.54	177.2	177.72	192919.0
2020-03-24 08:00:00	QQQ	ETF	177.43	180.11	174.6	177.27	424345.0
2020-03-24 08:30:00	QQQ	ETF	177.34	179.3	176.9	178.85	689995.0
2020-03-24 09:00:00	QQQ	ETF	179.0	180.01	178.37	179.9	641822.0
2020-03-24 09:30:00	QQQ	ETF	179.91	181.31	178.61	178.95	9890228.0
2020-03-24 10:00:00	QQQ	ETF	178.93	181.96	178.36	181.055	7323408.0
2020-03-24 10:30:00	QQQ	ETF	181.07	181.26	179.47	180.07	4115178.0
2020-03-24 11:00:00	QQQ	ETF	180.12	181.17	179.1608	180.91	3308492.0
2020-03-24 11:30:00	QQQ	ETF	180.92	182.12	180.27	181.8516	3636534.0
2020-03-24 12:00:00	QQQ	ETF	181.86	182.99	181.33	182.975	4074841.0
2020-03-24 12:30:00	QQQ	ETF	182.98	183.64	181.28	181.34	4051221.0

> showing 50 of 22,929 rows — these rows as CSV

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