PREVIEW / etf_30min / 2020-06-10

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-10.parquet
  size:    566 KB
  rows:    21,012

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-10 04:00:00	SPY	ETF	322.42	322.42	321.88	322.36	26766.0
2020-06-10 04:30:00	SPY	ETF	322.26	322.47	321.42	321.47	26984.0
2020-06-10 05:00:00	SPY	ETF	321.36	321.36	320.2	320.48	42267.0
2020-06-10 05:30:00	SPY	ETF	320.6	320.88	320.4	320.7	19467.0
2020-06-10 06:00:00	SPY	ETF	320.61	320.61	319.6	320.1	63760.0
2020-06-10 06:30:00	SPY	ETF	320.12	321.0	320.12	320.94	67282.0
2020-06-10 07:00:00	SPY	ETF	320.85	321.28	320.65	320.77	151242.0
2020-06-10 07:30:00	SPY	ETF	320.79	321.82	320.79	321.75	174743.0
2020-06-10 08:00:00	SPY	ETF	321.2299	322.71	319.9996	321.72	330396.0
2020-06-10 08:30:00	SPY	ETF	321.76	322.11	321.52	321.95	206050.0
2020-06-10 09:00:00	SPY	ETF	321.92	322.12	321.2	321.45	562514.0
2020-06-10 09:30:00	SPY	ETF	321.42	321.78	319.615	320.29	8698294.0
2020-06-10 10:00:00	SPY	ETF	320.29	320.5967	318.64	319.04	6786455.0
2020-06-10 10:30:00	SPY	ETF	319.01	320.03	318.2209	318.7	5882854.0
2020-06-10 11:00:00	SPY	ETF	318.69	319.95	318.55	319.64	6451729.0
2020-06-10 11:30:00	SPY	ETF	319.65	320.7769	318.91	319.71	4996444.0
2020-06-10 12:00:00	SPY	ETF	319.76	320.505	319.39	320.315	3365988.0
2020-06-10 12:30:00	SPY	ETF	320.31	320.38	319.95	320.23	2217391.0
2020-06-10 13:00:00	SPY	ETF	320.23	320.505	319.79	320.1	2143375.0
2020-06-10 13:30:00	SPY	ETF	320.1	320.4	319.8707	319.95	2234826.0
2020-06-10 14:00:00	SPY	ETF	319.91	322.39	318.94	322.09	11032642.0
2020-06-10 14:30:00	SPY	ETF	322.09	322.18	319.03	319.93	10385253.0
2020-06-10 15:00:00	SPY	ETF	319.94	321.41	318.88	321.3362	7838934.0
2020-06-10 15:30:00	SPY	ETF	321.32	321.48	318.89	319.01	12030736.0
2020-06-10 16:00:00	SPY	ETF	319.03	319.7647	318.31	318.65	7031241.0
2020-06-10 16:30:00	SPY	ETF	318.69	318.98	318.46	318.68	507426.0
2020-06-10 17:00:00	SPY	ETF	318.67	319.0	318.67	318.72	105560.0
2020-06-10 17:30:00	SPY	ETF	318.69	318.77	318.57	318.59	120086.0
2020-06-10 18:00:00	SPY	ETF	318.6	319.1	317.15	317.34	324790.0
2020-06-10 18:30:00	SPY	ETF	317.37	317.7	317.23	317.39	211236.0
2020-06-10 19:00:00	SPY	ETF	317.35	317.74	316.57	316.8	286544.0
2020-06-10 19:30:00	SPY	ETF	316.74	317.15	316.54	316.76	229895.0
2020-06-10 04:00:00	QQQ	ETF	244.17	244.36	244.04	244.36	25991.0
2020-06-10 04:30:00	QQQ	ETF	244.3	244.34	243.99	244.05	9918.0
2020-06-10 05:00:00	QQQ	ETF	244.02	244.02	243.38	243.55	23860.0
2020-06-10 05:30:00	QQQ	ETF	243.59	243.84	243.59	243.79	14935.0
2020-06-10 06:00:00	QQQ	ETF	243.71	243.71	243.1	243.19	35760.0
2020-06-10 06:30:00	QQQ	ETF	243.25	243.69	243.13	243.69	13005.0
2020-06-10 07:00:00	QQQ	ETF	243.66	244.25	243.63	243.97	128926.0
2020-06-10 07:30:00	QQQ	ETF	243.96	244.9	243.92	244.81	113689.0
2020-06-10 08:00:00	QQQ	ETF	243.5796	245.1	243.3896	244.75	241907.0
2020-06-10 08:30:00	QQQ	ETF	244.74	245.22	244.69	245.11	215095.0
2020-06-10 09:00:00	QQQ	ETF	245.15	245.25	244.815	245.0	277882.0
2020-06-10 09:30:00	QQQ	ETF	245.02	245.68	244.65	245.48	6138360.0
2020-06-10 10:00:00	QQQ	ETF	245.5	245.96	244.81	244.94	4720398.0
2020-06-10 10:30:00	QQQ	ETF	244.96	245.72	244.51	244.73	3716949.0
2020-06-10 11:00:00	QQQ	ETF	244.75	245.77	244.62	245.53	2104061.0
2020-06-10 11:30:00	QQQ	ETF	245.57	245.87	245.18	245.33	1949044.0
2020-06-10 12:00:00	QQQ	ETF	245.34	245.85	244.77	245.82	1791605.0
2020-06-10 12:30:00	QQQ	ETF	245.78	245.845	245.51	245.63	984968.0

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

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