PREVIEW / etf_30min / 2020-01-29

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-29.parquet
  size:    542 KB
  rows:    18,936

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-29 04:00:00	SPY	ETF	328.05	328.2	327.56	327.64	12344.0
2020-01-29 04:30:00	SPY	ETF	327.74	327.75	327.64	327.66	5690.0
2020-01-29 05:00:00	SPY	ETF	327.69	327.88	327.67	327.88	4589.0
2020-01-29 05:30:00	SPY	ETF	327.79	328.11	327.79	328.11	7575.0
2020-01-29 06:00:00	SPY	ETF	328.25	328.25	328.0	328.11	22124.0
2020-01-29 06:30:00	SPY	ETF	328.07	328.46	328.05	328.38	25712.0
2020-01-29 07:00:00	SPY	ETF	328.32	328.55	328.3	328.38	109526.0
2020-01-29 07:30:00	SPY	ETF	328.36	328.47	328.13	328.23	105804.0
2020-01-29 08:00:00	SPY	ETF	328.4499	328.55	327.76	328.23	112203.0
2020-01-29 08:30:00	SPY	ETF	328.2	328.27	327.86	327.96	215522.0
2020-01-29 09:00:00	SPY	ETF	328.0	328.4	327.97	328.38	178441.0
2020-01-29 09:30:00	SPY	ETF	328.38	328.47	327.15	327.27	4856992.0
2020-01-29 10:00:00	SPY	ETF	327.28	327.335	326.4	327.26	5299747.0
2020-01-29 10:30:00	SPY	ETF	327.27	327.89	327.11	327.82	2977981.0
2020-01-29 11:00:00	SPY	ETF	327.82	328.07	327.6	327.98	2175396.0
2020-01-29 11:30:00	SPY	ETF	327.98	328.06	327.62	327.92	1329300.0
2020-01-29 12:00:00	SPY	ETF	327.91	328.08	327.8601	328.0101	1459278.0
2020-01-29 12:30:00	SPY	ETF	328.02	328.02	327.77	327.83	1667710.0
2020-01-29 13:00:00	SPY	ETF	327.83	328.195	327.675	328.19	1314532.0
2020-01-29 13:30:00	SPY	ETF	328.18	328.31	327.95	328.04	1453164.0
2020-01-29 14:00:00	SPY	ETF	328.04	328.63	327.79	328.1865	2697037.0
2020-01-29 14:30:00	SPY	ETF	328.1811	328.28	327.74	327.7778	3076521.0
2020-01-29 15:00:00	SPY	ETF	327.78	327.89	326.72	327.45	7608789.0
2020-01-29 15:30:00	SPY	ETF	327.45	327.6	326.55	326.62	7609850.0
2020-01-29 16:00:00	SPY	ETF	326.64	326.86	326.35	326.42	7146547.0
2020-01-29 16:30:00	SPY	ETF	326.42	326.62	325.92	326.49	584372.0
2020-01-29 17:00:00	SPY	ETF	326.5	326.62	326.37	326.47	502782.0
2020-01-29 17:30:00	SPY	ETF	326.47	326.57	326.44	326.5	43460.0
2020-01-29 18:00:00	SPY	ETF	326.55	327.09	326.47	326.92	153491.0
2020-01-29 18:30:00	SPY	ETF	326.97	326.98	326.55	326.77	45913.0
2020-01-29 19:00:00	SPY	ETF	326.77	326.84	325.92	326.1	62938.0
2020-01-29 19:30:00	SPY	ETF	326.07	326.35	325.92	326.12	37427.0
2020-01-29 04:00:00	QQQ	ETF	222.32	222.45	222.06	222.08	82952.0
2020-01-29 04:30:00	QQQ	ETF	222.09	222.22	222.06	222.13	17346.0
2020-01-29 05:00:00	QQQ	ETF	222.19	222.34	222.18	222.32	23100.0
2020-01-29 05:30:00	QQQ	ETF	222.27	222.54	222.27	222.47	16977.0
2020-01-29 06:00:00	QQQ	ETF	222.52	222.64	222.45	222.46	6388.0
2020-01-29 06:30:00	QQQ	ETF	222.53	222.79	222.5	222.79	20434.0
2020-01-29 07:00:00	QQQ	ETF	222.7	222.83	222.6	222.66	83849.0
2020-01-29 07:30:00	QQQ	ETF	222.65	222.75	222.51	222.6	77019.0
2020-01-29 08:00:00	QQQ	ETF	222.81	222.8101	222.01	222.63	102852.0
2020-01-29 08:30:00	QQQ	ETF	222.67	222.69	222.36	222.4	96005.0
2020-01-29 09:00:00	QQQ	ETF	222.46	222.72	222.4	222.68	114657.0
2020-01-29 09:30:00	QQQ	ETF	222.66	222.93	221.52	221.62	3024265.0
2020-01-29 10:00:00	QQQ	ETF	221.6	221.6	220.83	221.4177	2341829.0
2020-01-29 10:30:00	QQQ	ETF	221.43	221.88	221.34	221.86	1385580.0
2020-01-29 11:00:00	QQQ	ETF	221.86	222.105	221.73	222.05	1100537.0
2020-01-29 11:30:00	QQQ	ETF	222.05	222.21	221.72	222.13	774751.0
2020-01-29 12:00:00	QQQ	ETF	222.135	222.375	222.07	222.33	622143.0
2020-01-29 12:30:00	QQQ	ETF	222.32	222.43	222.2	222.23	520489.0

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

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