PREVIEW / etf_30min / 2020-03-18

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-03-18.parquet
  size:    633 KB
  rows:    23,758

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-18 04:00:00	SPY	ETF	240.5	240.61	238.5	239.3	129244.0
2020-03-18 04:30:00	SPY	ETF	238.55	240.0	238.5	239.44	61601.0
2020-03-18 05:00:00	SPY	ETF	239.54	239.77	239.03	239.3	29438.0
2020-03-18 05:30:00	SPY	ETF	239.3	239.67	238.03	238.75	116256.0
2020-03-18 06:00:00	SPY	ETF	238.75	239.14	236.5	236.61	116390.0
2020-03-18 06:30:00	SPY	ETF	236.61	237.2	235.0	236.01	234968.0
2020-03-18 07:00:00	SPY	ETF	236.2	237.24	235.8	237.0	669506.0
2020-03-18 07:30:00	SPY	ETF	236.95	239.5	236.9	239.17	595987.0
2020-03-18 08:00:00	SPY	ETF	239.16	243.5	235.5	237.95	1054458.0
2020-03-18 08:30:00	SPY	ETF	237.95	238.0	236.05	237.0	1183100.0
2020-03-18 09:00:00	SPY	ETF	237.01	237.7	236.2	236.21	2332866.0
2020-03-18 09:30:00	SPY	ETF	236.25	244.38	236.22	242.58	30856472.0
2020-03-18 10:00:00	SPY	ETF	242.61	248.37	240.0	244.1	16283803.0
2020-03-18 10:30:00	SPY	ETF	244.07	246.42	240.15	240.26	13436422.0
2020-03-18 11:00:00	SPY	ETF	240.25	241.2	237.5	238.38	21310680.0
2020-03-18 11:30:00	SPY	ETF	238.36	241.49	237.08	241.06	18158862.0
2020-03-18 12:00:00	SPY	ETF	241.09	241.26	237.16	239.0	17597525.0
2020-03-18 12:30:00	SPY	ETF	239.05	239.42	235.67	235.73	20445932.0
2020-03-18 13:00:00	SPY	ETF	235.0	236.88	232.77	232.97	17147200.0
2020-03-18 13:30:00	SPY	ETF	232.96	234.98	230.0	231.88	24187517.0
2020-03-18 14:00:00	SPY	ETF	231.91	232.48	228.02	229.55	21269808.0
2020-03-18 14:30:00	SPY	ETF	229.591	235.18	228.76	235.09	22691234.0
2020-03-18 15:00:00	SPY	ETF	235.1	236.78	231.79	231.85	25868500.0
2020-03-18 15:30:00	SPY	ETF	231.83	241.87	231.0	241.01	48998823.0
2020-03-18 16:00:00	SPY	ETF	240.97	242.95	233.9196	241.0	15388610.0
2020-03-18 16:30:00	SPY	ETF	241.0	242.25	239.91	242.15	1481571.0
2020-03-18 17:00:00	SPY	ETF	242.16	242.1801	240.0	241.23	663165.0
2020-03-18 17:30:00	SPY	ETF	241.21	241.6	240.84	241.51	277629.0
2020-03-18 18:00:00	SPY	ETF	241.6	242.3	238.03	239.26	785014.0
2020-03-18 18:30:00	SPY	ETF	239.33	247.47	238.71	245.37	822356.0
2020-03-18 19:00:00	SPY	ETF	245.37	246.13	242.6	245.0	516116.0
2020-03-18 19:30:00	SPY	ETF	245.1	247.65	245.1	245.99	619984.0
2020-03-18 04:00:00	QQQ	ETF	171.31	172.96	171.0	172.81	29483.0
2020-03-18 04:30:00	QQQ	ETF	172.81	173.14	172.7	172.97	47592.0
2020-03-18 05:00:00	QQQ	ETF	172.84	172.99	172.6	172.6	6221.0
2020-03-18 05:30:00	QQQ	ETF	172.7	172.7	171.64	171.81	19727.0
2020-03-18 06:00:00	QQQ	ETF	171.81	172.5	170.89	170.89	34076.0
2020-03-18 06:30:00	QQQ	ETF	170.9	171.0	170.32	170.68	23101.0
2020-03-18 07:00:00	QQQ	ETF	170.68	171.69	170.5	171.09	94636.0
2020-03-18 07:30:00	QQQ	ETF	171.25	172.85	171.09	172.7	76865.0
2020-03-18 08:00:00	QQQ	ETF	171.39	175.17	170.51	172.46	231585.0
2020-03-18 08:30:00	QQQ	ETF	172.5	172.5	171.5	171.9	185680.0
2020-03-18 09:00:00	QQQ	ETF	171.87	172.5	171.3	171.58	592226.0
2020-03-18 09:30:00	QQQ	ETF	171.63	177.61	170.78	176.64	9403427.0
2020-03-18 10:00:00	QQQ	ETF	176.66	179.22	175.95	177.86	6358897.0
2020-03-18 10:30:00	QQQ	ETF	177.87	178.47	175.22	175.705	4023484.0
2020-03-18 11:00:00	QQQ	ETF	175.66	176.23	173.65	174.12	5749858.0
2020-03-18 11:30:00	QQQ	ETF	174.1	176.19	172.96	175.805	4746379.0
2020-03-18 12:00:00	QQQ	ETF	175.81	176.11	173.21	174.91	4350985.0
2020-03-18 12:30:00	QQQ	ETF	174.92	175.2	171.52	171.54	4548763.0

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

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