PREVIEW / etf_30min / 2020-11-19

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-11-19.parquet
  size:    574 KB
  rows:    21,298

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-11-19 04:00:00	SPY	ETF	354.84	355.47	354.42	355.17	41330.0
2020-11-19 04:30:00	SPY	ETF	355.17	355.26	354.8	354.8	14192.0
2020-11-19 05:00:00	SPY	ETF	354.8	355.12	354.21	355.12	19923.0
2020-11-19 05:30:00	SPY	ETF	355.12	355.41	355.12	355.24	14257.0
2020-11-19 06:00:00	SPY	ETF	355.19	355.38	354.74	354.94	22113.0
2020-11-19 06:30:00	SPY	ETF	355.04	356.0	355.03	355.82	36164.0
2020-11-19 07:00:00	SPY	ETF	355.92	356.24	355.88	356.01	98781.0
2020-11-19 07:30:00	SPY	ETF	356.02	356.33	356.0	356.03	165139.0
2020-11-19 08:00:00	SPY	ETF	355.8801	357.0	354.8104	355.87	178088.0
2020-11-19 08:30:00	SPY	ETF	355.76	355.96	355.24	355.94	238995.0
2020-11-19 09:00:00	SPY	ETF	355.98	355.98	355.4	355.59	213261.0
2020-11-19 09:30:00	SPY	ETF	355.6	356.36	354.15	356.115	7202274.0
2020-11-19 10:00:00	SPY	ETF	356.12	356.42	354.79	355.17	4699543.0
2020-11-19 10:30:00	SPY	ETF	355.17	356.71	355.08	355.93	4183542.0
2020-11-19 11:00:00	SPY	ETF	355.92	356.3	355.41	356.095	5225426.0
2020-11-19 11:30:00	SPY	ETF	356.1	356.27	355.353	355.9219	3746340.0
2020-11-19 12:00:00	SPY	ETF	355.93	356.23	355.5199	355.9097	2031115.0
2020-11-19 12:30:00	SPY	ETF	355.9	356.24	355.1911	355.5	2013256.0
2020-11-19 13:00:00	SPY	ETF	355.51	356.57	355.42	356.14	2713065.0
2020-11-19 13:30:00	SPY	ETF	356.14	356.67	356.01	356.53	2045847.0
2020-11-19 14:00:00	SPY	ETF	356.53	356.83	356.39	356.73	1621336.0
2020-11-19 14:30:00	SPY	ETF	356.73	358.13	356.71	357.68	4489568.0
2020-11-19 15:00:00	SPY	ETF	357.67	357.975	357.13	357.42	2868315.0
2020-11-19 15:30:00	SPY	ETF	357.42	358.18	357.23	357.745	7705431.0
2020-11-19 16:00:00	SPY	ETF	357.75	358.07	356.4162	357.53	5517644.0
2020-11-19 16:30:00	SPY	ETF	357.5	357.5	356.08	356.18	719047.0
2020-11-19 17:00:00	SPY	ETF	356.34	356.47	355.87	356.28	168930.0
2020-11-19 17:30:00	SPY	ETF	356.28	357.78	356.15	356.3	81045.0
2020-11-19 18:00:00	SPY	ETF	356.26	356.26	354.64	355.2	490836.0
2020-11-19 18:30:00	SPY	ETF	355.25	355.27	354.43	354.86	251279.0
2020-11-19 19:00:00	SPY	ETF	354.9	355.68	354.88	355.62	174133.0
2020-11-19 19:30:00	SPY	ETF	355.65	355.9	355.19	355.24	318211.0
2020-11-19 04:00:00	QQQ	ETF	288.14	288.81	287.99	288.81	29019.0
2020-11-19 04:30:00	QQQ	ETF	288.89	288.94	288.42	288.69	14395.0
2020-11-19 05:00:00	QQQ	ETF	288.77	288.86	288.34	288.84	10450.0
2020-11-19 05:30:00	QQQ	ETF	289.03	289.14	288.84	289.0	8947.0
2020-11-19 06:00:00	QQQ	ETF	289.03	289.03	288.52	288.94	12686.0
2020-11-19 06:30:00	QQQ	ETF	288.92	289.51	288.8	289.33	31408.0
2020-11-19 07:00:00	QQQ	ETF	289.5	289.69	289.38	289.42	100098.0
2020-11-19 07:30:00	QQQ	ETF	289.42	289.93	289.41	289.79	61243.0
2020-11-19 08:00:00	QQQ	ETF	289.5102	290.17	288.69	289.77	91575.0
2020-11-19 08:30:00	QQQ	ETF	289.69	289.77	289.38	289.71	83244.0
2020-11-19 09:00:00	QQQ	ETF	289.71	289.71	289.35	289.58	110462.0
2020-11-19 09:30:00	QQQ	ETF	289.48	290.88	288.85	290.75	3075453.0
2020-11-19 10:00:00	QQQ	ETF	290.79	290.92	289.87	290.52	1968273.0
2020-11-19 10:30:00	QQQ	ETF	290.54	291.57	290.4	291.12	1396227.0
2020-11-19 11:00:00	QQQ	ETF	291.12	291.495	290.71	291.42	831048.0
2020-11-19 11:30:00	QQQ	ETF	291.445	291.77	290.81	291.35	902079.0
2020-11-19 12:00:00	QQQ	ETF	291.35	291.81	291.0628	291.28	1037320.0
2020-11-19 12:30:00	QQQ	ETF	291.26	291.6	290.54	290.782	915204.0

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

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