PREVIEW / etf_30min / 2020-01-17

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-17.parquet
  size:    534 KB
  rows:    18,883

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
2020-01-17 04:00:00	SPY	ETF	331.4	331.55	331.4	331.54	1904.0
2020-01-17 04:30:00	SPY	ETF	331.51	331.59	331.47	331.59	4067.0
2020-01-17 05:00:00	SPY	ETF	331.69	331.89	331.66	331.74	6130.0
2020-01-17 05:30:00	SPY	ETF	331.61	331.67	331.6	331.6	1950.0
2020-01-17 06:00:00	SPY	ETF	331.63	331.66	331.51	331.66	3821.0
2020-01-17 06:30:00	SPY	ETF	331.6	331.69	331.6	331.66	17888.0
2020-01-17 07:00:00	SPY	ETF	331.65	331.69	331.49	331.56	70598.0
2020-01-17 07:30:00	SPY	ETF	331.55	331.58	331.44	331.52	53752.0
2020-01-17 08:00:00	SPY	ETF	331.61	331.66	330.93	331.64	86795.0
2020-01-17 08:30:00	SPY	ETF	331.65	332.02	331.6	331.67	365227.0
2020-01-17 09:00:00	SPY	ETF	331.68	331.84	331.47	331.75	396697.0
2020-01-17 09:30:00	SPY	ETF	331.7	331.76	331.18	331.675	5153177.0
2020-01-17 10:00:00	SPY	ETF	331.67	331.81	331.31	331.81	2868328.0
2020-01-17 10:30:00	SPY	ETF	331.8	331.82	331.335	331.48	6012986.0
2020-01-17 11:00:00	SPY	ETF	331.48	331.64	331.07	331.315	5734140.0
2020-01-17 11:30:00	SPY	ETF	331.31	331.6	331.3	331.55	5603972.0
2020-01-17 12:00:00	SPY	ETF	331.55	331.82	331.4675	331.78	5132857.0
2020-01-17 12:30:00	SPY	ETF	331.78	331.79	331.51	331.525	2377814.0
2020-01-17 13:00:00	SPY	ETF	331.53	331.79	331.5	331.615	2468578.0
2020-01-17 13:30:00	SPY	ETF	331.606	331.72	331.54	331.66	1140971.0
2020-01-17 14:00:00	SPY	ETF	331.66	331.79	331.59	331.61	4817682.0
2020-01-17 14:30:00	SPY	ETF	331.615	331.72	331.49	331.7175	1515684.0
2020-01-17 15:00:00	SPY	ETF	331.7101	331.77	331.3	331.625	7020670.0
2020-01-17 15:30:00	SPY	ETF	331.625	332.18	331.56	332.01	12126089.0
2020-01-17 16:00:00	SPY	ETF	331.99	332.1316	331.57	331.64	18764437.0
2020-01-17 16:30:00	SPY	ETF	331.62	332.1285	331.5	331.53	516957.0
2020-01-17 17:00:00	SPY	ETF	331.53	331.95	331.5	331.6	706656.0
2020-01-17 17:30:00	SPY	ETF	331.5201	331.64	331.5201	331.6	452092.0
2020-01-17 18:00:00	SPY	ETF	331.58	331.89	331.58	331.63	26389.0
2020-01-17 18:30:00	SPY	ETF	331.64	331.8	331.63	331.7	20785.0
2020-01-17 19:00:00	SPY	ETF	331.7	331.75	331.6	331.7	2186.0
2020-01-17 19:30:00	SPY	ETF	331.65	331.7	331.55	331.6	7305.0
2020-01-17 04:00:00	QQQ	ETF	222.68	222.86	222.68	222.82	15908.0
2020-01-17 04:30:00	QQQ	ETF	222.82	222.96	222.76	222.92	5118.0
2020-01-17 05:00:00	QQQ	ETF	222.96	223.11	222.94	223.0	8180.0
2020-01-17 05:30:00	QQQ	ETF	222.95	223.05	222.94	223.02	3400.0
2020-01-17 06:00:00	QQQ	ETF	223.04	223.09	222.98	223.0	6975.0
2020-01-17 06:30:00	QQQ	ETF	223.01	223.11	222.99	223.07	10200.0
2020-01-17 07:00:00	QQQ	ETF	223.08	223.09	222.97	223.0	27918.0
2020-01-17 07:30:00	QQQ	ETF	223.0	223.06	222.87	222.96	37424.0
2020-01-17 08:00:00	QQQ	ETF	223.02	223.0899	222.28	223.06	69452.0
2020-01-17 08:30:00	QQQ	ETF	223.07	223.33	223.04	223.19	184404.0
2020-01-17 09:00:00	QQQ	ETF	223.19	223.44	223.02	223.22	325862.0
2020-01-17 09:30:00	QQQ	ETF	223.21	223.3	222.37	222.81	2441290.0
2020-01-17 10:00:00	QQQ	ETF	222.81	222.96	222.5	222.94	1072626.0
2020-01-17 10:30:00	QQQ	ETF	222.94	222.96	222.48	222.55	821557.0
2020-01-17 11:00:00	QQQ	ETF	222.57	222.72	222.1221	222.34	1336857.0
2020-01-17 11:30:00	QQQ	ETF	222.34	222.55	222.32	222.52	653187.0
2020-01-17 12:00:00	QQQ	ETF	222.53	222.79	222.43	222.75	654986.0
2020-01-17 12:30:00	QQQ	ETF	222.76	222.76	222.52	222.53	479473.0

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

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