PREVIEW / etf_30min / 2019-04-01

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-04-01.parquet
  size:    516 KB
  rows:    18,179

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-04-01 04:00:00	SPY	ETF	284.51	284.81	284.51	284.75	10990.0
2019-04-01 04:30:00	SPY	ETF	284.75	284.89	284.69	284.71	8899.0
2019-04-01 05:00:00	SPY	ETF	284.75	284.77	284.45	284.45	18018.0
2019-04-01 05:30:00	SPY	ETF	284.49	284.57	284.4	284.41	6799.0
2019-04-01 06:00:00	SPY	ETF	284.42	284.5	284.26	284.3	11353.0
2019-04-01 06:30:00	SPY	ETF	284.32	284.4	284.26	284.28	25032.0
2019-04-01 07:00:00	SPY	ETF	284.24	284.6	284.23	284.54	50274.0
2019-04-01 07:30:00	SPY	ETF	284.54	284.61	284.42	284.57	98968.0
2019-04-01 08:00:00	SPY	ETF	284.6	284.74	282.48	284.5	220723.0
2019-04-01 08:30:00	SPY	ETF	284.48	284.7	284.1	284.5	387734.0
2019-04-01 09:00:00	SPY	ETF	284.5	284.74	284.5	284.69	290028.0
2019-04-01 09:30:00	SPY	ETF	284.7	284.88	284.4	284.51	8300387.0
2019-04-01 10:00:00	SPY	ETF	284.52	285.15	284.52	284.78	5886775.0
2019-04-01 10:30:00	SPY	ETF	284.78	284.95	284.69	284.855	2738888.0
2019-04-01 11:00:00	SPY	ETF	284.87	285.25	284.82	285.11	5368448.0
2019-04-01 11:30:00	SPY	ETF	285.1	285.17	284.74	285.0736	3559721.0
2019-04-01 12:00:00	SPY	ETF	285.0699	285.235	284.8199	285.16	2504189.0
2019-04-01 12:30:00	SPY	ETF	285.15	285.38	285.09	285.375	2167170.0
2019-04-01 13:00:00	SPY	ETF	285.375	285.46	285.16	285.33	4115296.0
2019-04-01 13:30:00	SPY	ETF	285.3325	285.56	285.28	285.5451	3188582.0
2019-04-01 14:00:00	SPY	ETF	285.54	285.81	285.51	285.53	4357239.0
2019-04-01 14:30:00	SPY	ETF	285.53	285.75	285.48	285.62	2757539.0
2019-04-01 15:00:00	SPY	ETF	285.615	285.77	285.32	285.76	4383680.0
2019-04-01 15:30:00	SPY	ETF	285.77	286.16	285.63	285.89	12452466.0
2019-04-01 16:00:00	SPY	ETF	285.89	285.9938	285.49	285.88	11326115.0
2019-04-01 16:30:00	SPY	ETF	285.9	286.0	285.83	285.87	356099.0
2019-04-01 17:00:00	SPY	ETF	285.89	285.92	285.75	285.84	171062.0
2019-04-01 17:30:00	SPY	ETF	285.82	285.852	285.72	285.72	320804.0
2019-04-01 18:00:00	SPY	ETF	285.71	285.78	285.58	285.72	53048.0
2019-04-01 18:30:00	SPY	ETF	285.73	285.73	285.61	285.63	19358.0
2019-04-01 19:00:00	SPY	ETF	285.68	285.92	285.62	285.62	193225.0
2019-04-01 19:30:00	SPY	ETF	285.65	286.0	285.65	285.97	52130.0
2019-04-01 04:00:00	QQQ	ETF	181.56	181.73	181.54	181.64	14510.0
2019-04-01 04:30:00	QQQ	ETF	181.73	181.79	181.64	181.65	15655.0
2019-04-01 05:00:00	QQQ	ETF	181.65	181.7	181.47	181.49	10140.0
2019-04-01 05:30:00	QQQ	ETF	181.47	181.52	181.4	181.42	7087.0
2019-04-01 06:00:00	QQQ	ETF	181.39	181.47	181.31	181.34	8595.0
2019-04-01 06:30:00	QQQ	ETF	181.34	181.4	181.3	181.3	6162.0
2019-04-01 07:00:00	QQQ	ETF	181.31	181.46	181.29	181.39	45723.0
2019-04-01 07:30:00	QQQ	ETF	181.39	181.43	181.3	181.42	50790.0
2019-04-01 08:00:00	QQQ	ETF	181.42	181.56	181.3	181.5	129033.0
2019-04-01 08:30:00	QQQ	ETF	181.49	181.52	181.17	181.32	136158.0
2019-04-01 09:00:00	QQQ	ETF	181.31	181.53	181.29	181.42	150135.0
2019-04-01 09:30:00	QQQ	ETF	181.38	181.71	181.02	181.1925	4838403.0
2019-04-01 10:00:00	QQQ	ETF	181.21	181.54	180.77	181.0866	2806149.0
2019-04-01 10:30:00	QQQ	ETF	181.09	181.31	180.95	181.26	1137523.0
2019-04-01 11:00:00	QQQ	ETF	181.27	181.74	181.2194	181.64	2079324.0
2019-04-01 11:30:00	QQQ	ETF	181.63	181.6389	181.42	181.52	1135389.0
2019-04-01 12:00:00	QQQ	ETF	181.52	181.57	181.29	181.54	1190435.0
2019-04-01 12:30:00	QQQ	ETF	181.53	181.9	181.52	181.9	1229847.0

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

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