PREVIEW / etf_30min / 2020-06-08

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-06-08.parquet
  size:    592 KB
  rows:    22,194

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-08 04:00:00	SPY	ETF	318.98	319.76	318.9	319.7	22857.0
2020-06-08 04:30:00	SPY	ETF	319.75	320.6	319.63	320.56	45900.0
2020-06-08 05:00:00	SPY	ETF	320.58	320.81	320.5	320.56	32148.0
2020-06-08 05:30:00	SPY	ETF	320.68	320.93	319.96	320.16	25171.0
2020-06-08 06:00:00	SPY	ETF	320.08	320.35	319.84	320.13	24202.0
2020-06-08 06:30:00	SPY	ETF	320.15	320.74	320.15	320.19	34778.0
2020-06-08 07:00:00	SPY	ETF	320.14	320.87	320.13	320.73	160549.0
2020-06-08 07:30:00	SPY	ETF	320.66	321.05	320.61	320.82	185980.0
2020-06-08 08:00:00	SPY	ETF	320.82	321.14	318.66	321.1	353030.0
2020-06-08 08:30:00	SPY	ETF	321.15	321.31	320.85	320.88	198580.0
2020-06-08 09:00:00	SPY	ETF	320.9	321.34	319.34	320.22	531493.0
2020-06-08 09:30:00	SPY	ETF	320.22	321.21	320.15	320.79	10582719.0
2020-06-08 10:00:00	SPY	ETF	320.79	320.9	319.69	319.9	5775235.0
2020-06-08 10:30:00	SPY	ETF	319.89	320.93	319.63	320.73	4667599.0
2020-06-08 11:00:00	SPY	ETF	320.75	321.37	320.67	321.16	3923760.0
2020-06-08 11:30:00	SPY	ETF	321.16	321.27	320.6	320.85	3345669.0
2020-06-08 12:00:00	SPY	ETF	320.855	321.12	320.48	320.538	2138987.0
2020-06-08 12:30:00	SPY	ETF	320.55	321.02	320.51	320.84	2088868.0
2020-06-08 13:00:00	SPY	ETF	320.84	321.2	320.74	321.085	1822913.0
2020-06-08 13:30:00	SPY	ETF	321.085	321.91	320.93	321.7627	3731288.0
2020-06-08 14:00:00	SPY	ETF	321.77	322.16	321.62	322.055	3291801.0
2020-06-08 14:30:00	SPY	ETF	322.055	322.14	321.775	322.069	3740804.0
2020-06-08 15:00:00	SPY	ETF	322.06	322.1	321.67	321.85	3327148.0
2020-06-08 15:30:00	SPY	ETF	321.85	323.41	321.79	323.25	15892783.0
2020-06-08 16:00:00	SPY	ETF	323.24	323.2689	322.63	322.96	5907986.0
2020-06-08 16:30:00	SPY	ETF	322.95	323.1	322.83	322.98	453885.0
2020-06-08 17:00:00	SPY	ETF	322.99	323.3	322.93	323.02	112563.0
2020-06-08 17:30:00	SPY	ETF	323.02	323.08	322.96	323.05	66682.0
2020-06-08 18:00:00	SPY	ETF	323.07	323.07	322.5	322.68	183077.0
2020-06-08 18:30:00	SPY	ETF	322.69	322.74	322.47	322.54	41737.0
2020-06-08 19:00:00	SPY	ETF	322.5399	322.86	322.5	322.8	46051.0
2020-06-08 19:30:00	SPY	ETF	322.77	322.79	322.45	322.61	57398.0
2020-06-08 04:00:00	QQQ	ETF	239.24	239.53	239.16	239.51	140001.0
2020-06-08 04:30:00	QQQ	ETF	239.41	239.88	239.41	239.88	10298.0
2020-06-08 05:00:00	QQQ	ETF	239.93	240.04	239.89	239.93	24200.0
2020-06-08 05:30:00	QQQ	ETF	239.87	239.99	239.5	239.51	28719.0
2020-06-08 06:00:00	QQQ	ETF	239.49	239.58	239.35	239.58	19265.0
2020-06-08 06:30:00	QQQ	ETF	239.54	239.85	239.53	239.55	7532.0
2020-06-08 07:00:00	QQQ	ETF	239.55	239.73	239.44	239.66	48213.0
2020-06-08 07:30:00	QQQ	ETF	239.64	239.78	239.24	239.43	105118.0
2020-06-08 08:00:00	QQQ	ETF	239.6	240.37	238.87	239.25	148617.0
2020-06-08 08:30:00	QQQ	ETF	239.27	239.75	239.27	239.63	133793.0
2020-06-08 09:00:00	QQQ	ETF	239.68	239.92	239.32	239.46	334655.0
2020-06-08 09:30:00	QQQ	ETF	239.45	239.92	238.46	238.83	4837436.0
2020-06-08 10:00:00	QQQ	ETF	238.83	238.89	237.91	238.62	3173530.0
2020-06-08 10:30:00	QQQ	ETF	238.62	239.46	238.58	239.22	1925372.0
2020-06-08 11:00:00	QQQ	ETF	239.23	239.79	239.23	239.71	1579163.0
2020-06-08 11:30:00	QQQ	ETF	239.72	239.81	239.151	239.46	1475608.0
2020-06-08 12:00:00	QQQ	ETF	239.47	239.64	239.06	239.23	1178886.0
2020-06-08 12:30:00	QQQ	ETF	239.23	239.78	239.22	239.66	989887.0

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

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