PREVIEW / etf_30min / 2020-06-09

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-09.parquet
  size:    576 KB
  rows:    21,365

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-09 04:00:00	SPY	ETF	321.14	321.37	319.9	320.16	90848.0
2020-06-09 04:30:00	SPY	ETF	320.2	320.39	319.33	319.67	56959.0
2020-06-09 05:00:00	SPY	ETF	319.82	320.49	319.7	320.35	71583.0
2020-06-09 05:30:00	SPY	ETF	320.4	320.46	319.54	319.71	111232.0
2020-06-09 06:00:00	SPY	ETF	319.77	320.0	319.34	319.41	61748.0
2020-06-09 06:30:00	SPY	ETF	319.51	320.35	319.51	320.25	182180.0
2020-06-09 07:00:00	SPY	ETF	320.27	320.44	319.9	320.0	258355.0
2020-06-09 07:30:00	SPY	ETF	320.04	320.86	319.9	320.52	356793.0
2020-06-09 08:00:00	SPY	ETF	320.51	323.24	319.4704	320.61	334839.0
2020-06-09 08:30:00	SPY	ETF	320.55	320.74	319.73	319.97	533165.0
2020-06-09 09:00:00	SPY	ETF	319.95	320.33	319.78	320.24	349674.0
2020-06-09 09:30:00	SPY	ETF	320.3	320.76	319.655	319.76	7438638.0
2020-06-09 10:00:00	SPY	ETF	319.79	320.45	319.36	320.1199	6513085.0
2020-06-09 10:30:00	SPY	ETF	320.11	321.69	320.031	321.37	5557254.0
2020-06-09 11:00:00	SPY	ETF	321.365	321.75	320.93	321.32	4579906.0
2020-06-09 11:30:00	SPY	ETF	321.315	323.2849	320.47	320.62	3477621.0
2020-06-09 12:00:00	SPY	ETF	320.63	320.99	320.16	320.98	3473842.0
2020-06-09 12:30:00	SPY	ETF	320.98	321.449	320.33	321.415	1941654.0
2020-06-09 13:00:00	SPY	ETF	321.41	321.94	321.26	321.935	2937037.0
2020-06-09 13:30:00	SPY	ETF	321.93	322.22	321.87	321.97	2791390.0
2020-06-09 14:00:00	SPY	ETF	321.97	322.08	320.95	321.01	3802862.0
2020-06-09 14:30:00	SPY	ETF	321.01	321.75	320.96	321.71	4801328.0
2020-06-09 15:00:00	SPY	ETF	321.7	322.365	321.33	322.205	4842515.0
2020-06-09 15:30:00	SPY	ETF	322.205	322.22	320.48	320.81	15485088.0
2020-06-09 16:00:00	SPY	ETF	320.83	321.41	320.67	320.72	5871122.0
2020-06-09 16:30:00	SPY	ETF	320.72	320.77	320.44	320.75	729839.0
2020-06-09 17:00:00	SPY	ETF	320.75	320.8	320.65	320.66	64837.0
2020-06-09 17:30:00	SPY	ETF	320.69	320.86	320.63	320.78	38107.0
2020-06-09 18:00:00	SPY	ETF	320.75	321.09	320.75	320.96	78489.0
2020-06-09 18:30:00	SPY	ETF	320.96	321.54	320.8	321.43	63969.0
2020-06-09 19:00:00	SPY	ETF	321.4	321.4	320.96	321.3	28574.0
2020-06-09 19:30:00	SPY	ETF	321.29	321.95	321.19	321.92	132145.0
2020-06-09 04:00:00	QQQ	ETF	240.91	240.91	239.85	239.88	55543.0
2020-06-09 04:30:00	QQQ	ETF	240.0	240.03	239.62	239.74	30748.0
2020-06-09 05:00:00	QQQ	ETF	239.83	240.13	239.76	240.13	13293.0
2020-06-09 05:30:00	QQQ	ETF	240.18	240.18	239.87	239.88	12114.0
2020-06-09 06:00:00	QQQ	ETF	239.91	240.0	239.55	239.74	44892.0
2020-06-09 06:30:00	QQQ	ETF	239.75	240.23	239.75	240.19	91576.0
2020-06-09 07:00:00	QQQ	ETF	240.25	240.3	239.78	239.82	76918.0
2020-06-09 07:30:00	QQQ	ETF	239.83	240.37	239.82	240.33	82931.0
2020-06-09 08:00:00	QQQ	ETF	240.3301	241.64	239.62	240.46	116190.0
2020-06-09 08:30:00	QQQ	ETF	240.43	240.7	240.27	240.6	132260.0
2020-06-09 09:00:00	QQQ	ETF	240.66	240.75	240.35	240.56	123591.0
2020-06-09 09:30:00	QQQ	ETF	240.63	241.88	240.47	241.51	3565790.0
2020-06-09 10:00:00	QQQ	ETF	241.54	241.96	241.02	241.68	3008222.0
2020-06-09 10:30:00	QQQ	ETF	241.68	243.23	241.68	243.18	2732171.0
2020-06-09 11:00:00	QQQ	ETF	243.1788	243.42	242.66	243.16	2897097.0
2020-06-09 11:30:00	QQQ	ETF	243.16	243.35	242.69	242.81	1769962.0
2020-06-09 12:00:00	QQQ	ETF	242.81	243.35	242.55	243.27	1491764.0
2020-06-09 12:30:00	QQQ	ETF	243.26	243.745	242.98	243.5499	1243650.0

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

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