PREVIEW / etf_30min / 2019-12-27

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-12-27.parquet
  size:    515 KB
  rows:    18,389

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-27 04:00:00	SPY	ETF	323.61	323.67	323.54	323.57	4382.0
2019-12-27 04:30:00	SPY	ETF	323.62	323.62	323.53	323.58	874.0
2019-12-27 05:00:00	SPY	ETF	323.72	323.89	323.72	323.81	3560.0
2019-12-27 05:30:00	SPY	ETF	323.95	324.03	323.89	323.95	3646.0
2019-12-27 06:00:00	SPY	ETF	323.94	324.03	323.84	323.87	6062.0
2019-12-27 06:30:00	SPY	ETF	323.9	324.02	323.9	323.95	6170.0
2019-12-27 07:00:00	SPY	ETF	323.95	323.99	323.89	323.93	23516.0
2019-12-27 07:30:00	SPY	ETF	323.99	324.0	323.86	323.86	10946.0
2019-12-27 08:00:00	SPY	ETF	323.88	324.05	323.5	323.95	80119.0
2019-12-27 08:30:00	SPY	ETF	323.97	324.06	322.94	323.74	182286.0
2019-12-27 09:00:00	SPY	ETF	323.75	323.84	323.6	323.77	127500.0
2019-12-27 09:30:00	SPY	ETF	323.74	323.8	322.51	322.55	4253829.0
2019-12-27 10:00:00	SPY	ETF	322.55	323.09	322.485	323.045	3440788.0
2019-12-27 10:30:00	SPY	ETF	323.04	323.26	322.86	323.205	1886357.0
2019-12-27 11:00:00	SPY	ETF	323.22	323.425	323.2005	323.34	3169776.0
2019-12-27 11:30:00	SPY	ETF	323.35	323.48	323.28	323.28	2660761.0
2019-12-27 12:00:00	SPY	ETF	323.28	323.37	323.052	323.07	1627272.0
2019-12-27 12:30:00	SPY	ETF	323.085	323.27	323.03	323.25	779208.0
2019-12-27 13:00:00	SPY	ETF	323.25	323.2961	322.93	322.94	2028770.0
2019-12-27 13:30:00	SPY	ETF	322.94	323.03	322.85	322.91	1599567.0
2019-12-27 14:00:00	SPY	ETF	322.92	323.1297	322.91	323.09	2390495.0
2019-12-27 14:30:00	SPY	ETF	323.1	323.3	323.09	323.247	1756003.0
2019-12-27 15:00:00	SPY	ETF	323.24	323.25	323.0	323.03	1438723.0
2019-12-27 15:30:00	SPY	ETF	323.025	323.1	322.28	322.86	8091513.0
2019-12-27 16:00:00	SPY	ETF	322.84	322.8944	322.44	322.5	5600529.0
2019-12-27 16:30:00	SPY	ETF	322.51	322.86	322.35	322.42	245273.0
2019-12-27 17:00:00	SPY	ETF	322.41	322.54	322.41	322.52	10942.0
2019-12-27 17:30:00	SPY	ETF	322.46	322.53	322.46	322.53	824.0
2019-12-27 18:00:00	SPY	ETF	322.5	322.5	322.45	322.45	8141.0
2019-12-27 18:30:00	SPY	ETF	322.44	322.45	322.44	322.45	4217.0
2019-12-27 19:00:00	SPY	ETF	322.44	322.49	322.44	322.49	1646.0
2019-12-27 19:30:00	SPY	ETF	322.45	322.45	322.29	322.39	15230.0
2019-12-27 04:00:00	QQQ	ETF	214.42	214.46	214.36	214.4	15730.0
2019-12-27 04:30:00	QQQ	ETF	214.36	214.4	214.34	214.38	7579.0
2019-12-27 05:00:00	QQQ	ETF	214.4	214.56	214.37	214.53	12677.0
2019-12-27 05:30:00	QQQ	ETF	214.58	214.66	214.56	214.66	11155.0
2019-12-27 06:00:00	QQQ	ETF	214.76	214.76	214.59	214.6	8660.0
2019-12-27 06:30:00	QQQ	ETF	214.59	214.69	214.59	214.67	12535.0
2019-12-27 07:00:00	QQQ	ETF	214.67	214.75	214.63	214.75	41284.0
2019-12-27 07:30:00	QQQ	ETF	214.75	214.78	214.59	214.67	25611.0
2019-12-27 08:00:00	QQQ	ETF	214.65	214.79	213.79	214.7299	64077.0
2019-12-27 08:30:00	QQQ	ETF	214.75	214.79	214.59	214.6	58485.0
2019-12-27 09:00:00	QQQ	ETF	214.6	214.67	214.42	214.57	86096.0
2019-12-27 09:30:00	QQQ	ETF	214.55	214.56	213.295	213.32	2834411.0
2019-12-27 10:00:00	QQQ	ETF	213.32	214.0	213.2847	213.92	1306611.0
2019-12-27 10:30:00	QQQ	ETF	213.91	214.09	213.78	214.0	716735.0
2019-12-27 11:00:00	QQQ	ETF	214.01	214.19	214.01	214.15	689561.0
2019-12-27 11:30:00	QQQ	ETF	214.155	214.26	214.01	214.01	447249.0
2019-12-27 12:00:00	QQQ	ETF	214.0065	214.11	213.7846	213.8	588574.0
2019-12-27 12:30:00	QQQ	ETF	213.81	213.9201	213.69	213.91	628324.0

> showing 50 of 18,389 rows — these rows as CSV

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