PREVIEW / etf_30min / 2019-01-15

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-15.parquet
  size:    491 KB
  rows:    17,250

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-01-15 04:00:00	SPY	ETF	258.42	258.42	258.05	258.26	4412.0
2019-01-15 04:30:00	SPY	ETF	258.26	258.33	257.89	257.9	14676.0
2019-01-15 05:00:00	SPY	ETF	258.04	258.19	258.0	258.08	5595.0
2019-01-15 05:30:00	SPY	ETF	258.01	258.34	257.9	258.3	5994.0
2019-01-15 06:00:00	SPY	ETF	258.21	258.4	258.2	258.27	13710.0
2019-01-15 06:30:00	SPY	ETF	258.21	258.54	257.49	257.65	79532.0
2019-01-15 07:00:00	SPY	ETF	257.66	257.82	257.5	257.78	158787.0
2019-01-15 07:30:00	SPY	ETF	257.72	257.73	257.54	257.72	90514.0
2019-01-15 08:00:00	SPY	ETF	257.68	259.22	257.5201	257.58	240047.0
2019-01-15 08:30:00	SPY	ETF	257.61	257.75	257.41	257.7	183962.0
2019-01-15 09:00:00	SPY	ETF	257.69	257.93	257.6	257.79	336339.0
2019-01-15 09:30:00	SPY	ETF	257.82	259.4	257.81	259.13	7710418.0
2019-01-15 10:00:00	SPY	ETF	259.14	260.04	258.62	258.96	9763594.0
2019-01-15 10:30:00	SPY	ETF	258.97	259.62	258.6801	259.53	6608275.0
2019-01-15 11:00:00	SPY	ETF	259.53	259.82	259.105	259.36	3777096.0
2019-01-15 11:30:00	SPY	ETF	259.375	260.28	259.18	260.16	4774091.0
2019-01-15 12:00:00	SPY	ETF	260.16	260.7	260.12	260.415	5134559.0
2019-01-15 12:30:00	SPY	ETF	260.4128	260.45	259.895	260.08	2682185.0
2019-01-15 13:00:00	SPY	ETF	260.09	260.17	259.8515	260.0881	2359000.0
2019-01-15 13:30:00	SPY	ETF	260.08	260.29	259.97	260.1388	2349140.0
2019-01-15 14:00:00	SPY	ETF	260.13	260.45	259.05	259.115	4304435.0
2019-01-15 14:30:00	SPY	ETF	259.12	259.73	258.72	259.6985	7236741.0
2019-01-15 15:00:00	SPY	ETF	259.7	260.21	259.5834	259.9867	4080509.0
2019-01-15 15:30:00	SPY	ETF	259.99	260.58	259.83	260.38	12180438.0
2019-01-15 16:00:00	SPY	ETF	260.38	260.4084	259.77	259.86	9211872.0
2019-01-15 16:30:00	SPY	ETF	259.86	260.35	259.75	259.95	266100.0
2019-01-15 17:00:00	SPY	ETF	259.98	260.05	259.9	260.05	42124.0
2019-01-15 17:30:00	SPY	ETF	260.02	260.09	259.91	259.96	89511.0
2019-01-15 18:00:00	SPY	ETF	259.91	260.44	259.85	260.26	125583.0
2019-01-15 18:30:00	SPY	ETF	260.21	260.5	260.17	260.43	34272.0
2019-01-15 19:00:00	SPY	ETF	260.37	260.37	259.91	260.04	46665.0
2019-01-15 19:30:00	SPY	ETF	260.01	260.43	259.96	260.11	45037.0
2019-01-15 04:00:00	QQQ	ETF	160.0	160.0	159.81	159.98	4931.0
2019-01-15 04:30:00	QQQ	ETF	159.97	160.01	159.65	159.66	4545.0
2019-01-15 05:00:00	QQQ	ETF	159.74	159.87	159.74	159.85	2522.0
2019-01-15 05:30:00	QQQ	ETF	159.7	160.01	159.69	160.0	6600.0
2019-01-15 06:00:00	QQQ	ETF	159.99	160.16	159.91	159.97	14350.0
2019-01-15 06:30:00	QQQ	ETF	159.95	160.11	159.6	159.72	21374.0
2019-01-15 07:00:00	QQQ	ETF	159.7	159.85	159.59	159.83	69456.0
2019-01-15 07:30:00	QQQ	ETF	159.79	159.85	159.67	159.84	24642.0
2019-01-15 08:00:00	QQQ	ETF	159.57	160.59	159.57	159.74	91533.0
2019-01-15 08:30:00	QQQ	ETF	159.77	159.82	159.61	159.77	117967.0
2019-01-15 09:00:00	QQQ	ETF	159.8	160.0	159.74	159.93	231806.0
2019-01-15 09:30:00	QQQ	ETF	159.94	161.66	159.9096	161.565	5523391.0
2019-01-15 10:00:00	QQQ	ETF	161.57	162.15	161.29	161.47	5163840.0
2019-01-15 10:30:00	QQQ	ETF	161.5	161.76	161.24	161.66	2378237.0
2019-01-15 11:00:00	QQQ	ETF	161.66	161.77	161.39	161.56	1749939.0
2019-01-15 11:30:00	QQQ	ETF	161.57	162.31	161.49	162.26	2113603.0
2019-01-15 12:00:00	QQQ	ETF	162.27	162.6	162.26	162.3766	1934119.0
2019-01-15 12:30:00	QQQ	ETF	162.3722	162.42	162.16	162.26	1387885.0

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

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