PREVIEW / etf_30min / 2019-03-20

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-03-20.parquet
  size:    497 KB
  rows:    17,320

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
2019-03-20 04:00:00	SPY	ETF	282.43	282.55	282.33	282.52	5871.0
2019-03-20 04:30:00	SPY	ETF	282.53	282.76	282.51	282.73	9339.0
2019-03-20 05:00:00	SPY	ETF	282.67	282.67	282.47	282.52	6405.0
2019-03-20 05:30:00	SPY	ETF	282.54	282.54	282.36	282.36	7900.0
2019-03-20 06:00:00	SPY	ETF	282.4	282.44	282.18	282.24	4801.0
2019-03-20 06:30:00	SPY	ETF	282.25	282.25	281.98	282.03	65193.0
2019-03-20 07:00:00	SPY	ETF	282.06	282.09	281.89	282.02	31340.0
2019-03-20 07:30:00	SPY	ETF	282.02	282.25	281.95	282.24	44937.0
2019-03-20 08:00:00	SPY	ETF	282.29	282.45	281.95	282.3	110609.0
2019-03-20 08:30:00	SPY	ETF	282.29	282.33	281.87	281.88	174304.0
2019-03-20 09:00:00	SPY	ETF	281.86	282.22	281.86	282.16	390225.0
2019-03-20 09:30:00	SPY	ETF	282.16	282.2327	281.21	281.3	6365122.0
2019-03-20 10:00:00	SPY	ETF	281.3	281.795	281.08	281.44	4409094.0
2019-03-20 10:30:00	SPY	ETF	281.44	281.71	281.24	281.625	2692993.0
2019-03-20 11:00:00	SPY	ETF	281.63	281.85	281.44	281.6	3065343.0
2019-03-20 11:30:00	SPY	ETF	281.5926	281.68	280.6501	280.7596	3666862.0
2019-03-20 12:00:00	SPY	ETF	280.76	281.22	280.76	281.145	2802657.0
2019-03-20 12:30:00	SPY	ETF	281.14	281.14	280.32	280.91	4833030.0
2019-03-20 13:00:00	SPY	ETF	280.9	281.08	280.79	280.8417	1660813.0
2019-03-20 13:30:00	SPY	ETF	280.845	281.2989	280.805	281.24	2350673.0
2019-03-20 14:00:00	SPY	ETF	281.24	283.15	281.24	283.11	14093378.0
2019-03-20 14:30:00	SPY	ETF	283.11	283.5	282.79	283.14	7465481.0
2019-03-20 15:00:00	SPY	ETF	283.16	283.36	282.46	282.59	6195448.0
2019-03-20 15:30:00	SPY	ETF	282.59	282.59	281.42	281.53	15554111.0
2019-03-20 16:00:00	SPY	ETF	281.52	281.55	281.15	281.23	6470991.0
2019-03-20 16:30:00	SPY	ETF	281.24	281.25	280.85	280.92	423735.0
2019-03-20 17:00:00	SPY	ETF	280.97	281.0	280.9	281.0	97155.0
2019-03-20 17:30:00	SPY	ETF	280.97	281.04	280.97	281.01	77558.0
2019-03-20 18:00:00	SPY	ETF	280.99	281.12	280.9	281.11	80485.0
2019-03-20 18:30:00	SPY	ETF	281.1	281.25	281.08	281.14	53354.0
2019-03-20 19:00:00	SPY	ETF	281.17	281.38	281.16	281.38	21596.0
2019-03-20 19:30:00	SPY	ETF	281.38	281.49	281.38	281.4	31524.0
2019-03-20 04:00:00	QQQ	ETF	179.08	179.08	179.06	179.08	2005.0
2019-03-20 04:30:00	QQQ	ETF	179.19	179.29	179.19	179.25	4519.0
2019-03-20 05:00:00	QQQ	ETF	179.17	179.22	179.13	179.21	6407.0
2019-03-20 05:30:00	QQQ	ETF	179.19	179.19	179.01	179.07	9450.0
2019-03-20 06:00:00	QQQ	ETF	179.07	179.12	178.92	178.99	7122.0
2019-03-20 06:30:00	QQQ	ETF	179.02	179.02	178.88	178.91	5429.0
2019-03-20 07:00:00	QQQ	ETF	178.92	178.94	178.74	178.86	37897.0
2019-03-20 07:30:00	QQQ	ETF	178.9	179.06	178.84	179.06	31532.0
2019-03-20 08:00:00	QQQ	ETF	178.89	179.17	178.67	179.05	44727.0
2019-03-20 08:30:00	QQQ	ETF	179.08	179.11	178.82	178.84	30461.0
2019-03-20 09:00:00	QQQ	ETF	178.88	179.08	178.87	179.05	139312.0
2019-03-20 09:30:00	QQQ	ETF	179.05	179.11	178.49	178.66	3296967.0
2019-03-20 10:00:00	QQQ	ETF	178.66	179.19	178.63	178.98	3356401.0
2019-03-20 10:30:00	QQQ	ETF	178.99	179.22	178.77	179.14	1819232.0
2019-03-20 11:00:00	QQQ	ETF	179.15	179.25	178.94	179.04	1570292.0
2019-03-20 11:30:00	QQQ	ETF	179.04	179.1	178.41	178.4856	1416470.0
2019-03-20 12:00:00	QQQ	ETF	178.49	178.92	178.49	178.87	1296450.0
2019-03-20 12:30:00	QQQ	ETF	178.86	178.9	178.24	178.7299	2315677.0

> showing 50 of 17,320 rows — these rows as CSV

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