PREVIEW / etf_30min / 2019-12-26

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-26.parquet
  size:    505 KB
  rows:    17,783

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-12-26 04:00:00	SPY	ETF	321.54	321.79	321.54	321.79	7759.0
2019-12-26 04:30:00	SPY	ETF	321.79	321.79	321.76	321.76	567.0
2019-12-26 05:00:00	SPY	ETF	321.79	321.8	321.79	321.79	1800.0
2019-12-26 05:30:00	SPY	ETF	321.77	321.77	321.77	321.77	100.0
2019-12-26 06:00:00	SPY	ETF	321.77	321.77	321.77	321.77	200.0
2019-12-26 06:30:00	SPY	ETF	321.77	321.77	321.75	321.75	400.0
2019-12-26 07:00:00	SPY	ETF	321.75	321.78	321.73	321.73	7128.0
2019-12-26 07:30:00	SPY	ETF	321.74	321.77	321.7	321.76	11671.0
2019-12-26 08:00:00	SPY	ETF	321.76	321.97	321.65	321.95	69457.0
2019-12-26 08:30:00	SPY	ETF	321.87	321.89	321.74	321.8	123985.0
2019-12-26 09:00:00	SPY	ETF	321.75	321.87	321.65	321.65	67905.0
2019-12-26 09:30:00	SPY	ETF	321.65	322.14	321.64	321.985	2254354.0
2019-12-26 10:00:00	SPY	ETF	321.99	322.2	321.98	322.14	1265929.0
2019-12-26 10:30:00	SPY	ETF	322.14	322.355	322.14	322.29	3069075.0
2019-12-26 11:00:00	SPY	ETF	322.29	322.47	322.2819	322.305	2995374.0
2019-12-26 11:30:00	SPY	ETF	322.305	322.34	322.2	322.285	998971.0
2019-12-26 12:00:00	SPY	ETF	322.28	322.29	321.99	322.055	1841199.0
2019-12-26 12:30:00	SPY	ETF	322.05	322.24	322.03	322.2	1030556.0
2019-12-26 13:00:00	SPY	ETF	322.2099	322.36	322.17	322.3195	1325782.0
2019-12-26 13:30:00	SPY	ETF	322.315	322.39	322.28	322.34	944720.0
2019-12-26 14:00:00	SPY	ETF	322.34	322.44	322.29	322.3	964635.0
2019-12-26 14:30:00	SPY	ETF	322.3	322.31	322.19	322.2	1007029.0
2019-12-26 15:00:00	SPY	ETF	322.2	322.28	322.15	322.185	1595430.0
2019-12-26 15:30:00	SPY	ETF	322.185	322.93	322.02	322.91	7821038.0
2019-12-26 16:00:00	SPY	ETF	322.9	323.14	322.84	323.05	2543558.0
2019-12-26 16:30:00	SPY	ETF	323.04	323.04	322.83	322.89	201545.0
2019-12-26 17:00:00	SPY	ETF	322.86	322.93	322.86	322.92	11601.0
2019-12-26 17:30:00	SPY	ETF	322.93	322.94	322.92	322.93	5994.0
2019-12-26 18:00:00	SPY	ETF	322.93	323.03	322.88	323.03	58898.0
2019-12-26 18:30:00	SPY	ETF	323.0	323.01	322.95	323.0	8969.0
2019-12-26 19:00:00	SPY	ETF	323.0	323.12	322.95	323.11	13688.0
2019-12-26 19:30:00	SPY	ETF	323.18	323.39	323.16	323.39	86524.0
2019-12-26 04:00:00	QQQ	ETF	212.1	212.28	212.1	212.28	4900.0
2019-12-26 04:30:00	QQQ	ETF	212.28	212.28	212.26	212.27	3000.0
2019-12-26 05:00:00	QQQ	ETF	212.27	212.28	212.25	212.25	600.0
2019-12-26 05:30:00	QQQ	ETF	212.25	212.28	212.25	212.27	600.0
2019-12-26 06:00:00	QQQ	ETF	212.28	212.3	212.27	212.27	2100.0
2019-12-26 06:30:00	QQQ	ETF	212.26	212.33	212.25	212.25	3643.0
2019-12-26 07:00:00	QQQ	ETF	212.25	212.28	212.21	212.22	9129.0
2019-12-26 07:30:00	QQQ	ETF	212.25	212.29	212.22	212.29	3341.0
2019-12-26 08:00:00	QQQ	ETF	212.23	212.48	212.2	212.43	57808.0
2019-12-26 08:30:00	QQQ	ETF	212.41	212.44	212.35	212.35	31765.0
2019-12-26 09:00:00	QQQ	ETF	212.31	212.41	212.26	212.26	34535.0
2019-12-26 09:30:00	QQQ	ETF	212.26	212.77	212.23	212.68	1675719.0
2019-12-26 10:00:00	QQQ	ETF	212.68	212.895	212.68	212.79	701497.0
2019-12-26 10:30:00	QQQ	ETF	212.79	212.97	212.765	212.94	486619.0
2019-12-26 11:00:00	QQQ	ETF	212.94	213.15	212.94	213.07	708769.0
2019-12-26 11:30:00	QQQ	ETF	213.06	213.25	213.04	213.2	514690.0
2019-12-26 12:00:00	QQQ	ETF	213.2	213.21	212.91	212.985	736190.0
2019-12-26 12:30:00	QQQ	ETF	212.9836	213.15	212.97	213.14	306715.0

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

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