PREVIEW / etf_30min / 2019-10-18

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-10-18.parquet
  size:    489 KB
  rows:    16,956

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-10-18 04:00:00	SPY	ETF	299.03	299.12	298.95	298.95	1415.0
2019-10-18 04:30:00	SPY	ETF	298.92	299.12	298.9	299.12	4336.0
2019-10-18 05:00:00	SPY	ETF	298.95	299.3	298.95	299.2	1700.0
2019-10-18 05:30:00	SPY	ETF	299.15	299.33	299.07	299.3	3385.0
2019-10-18 06:00:00	SPY	ETF	299.28	299.34	299.19	299.19	10965.0
2019-10-18 06:30:00	SPY	ETF	299.14	299.37	299.14	299.37	25190.0
2019-10-18 07:00:00	SPY	ETF	299.35	299.46	299.31	299.34	59788.0
2019-10-18 07:30:00	SPY	ETF	299.44	299.57	299.41	299.51	108472.0
2019-10-18 08:00:00	SPY	ETF	299.3501	299.56	298.45	299.46	124443.0
2019-10-18 08:30:00	SPY	ETF	299.47	299.52	299.25	299.28	77825.0
2019-10-18 09:00:00	SPY	ETF	299.25	299.29	298.49	298.66	537733.0
2019-10-18 09:30:00	SPY	ETF	298.69	299.395	298.69	299.31	3681405.0
2019-10-18 10:00:00	SPY	ETF	299.3	299.31	298.6	298.79	3209565.0
2019-10-18 10:30:00	SPY	ETF	298.8001	298.82	298.13	298.63	5790644.0
2019-10-18 11:00:00	SPY	ETF	298.63	298.935	298.45	298.79	2587402.0
2019-10-18 11:30:00	SPY	ETF	298.79	298.92	297.95	297.99	4079549.0
2019-10-18 12:00:00	SPY	ETF	297.98	298.9554	296.99	297.38	5479735.0
2019-10-18 12:30:00	SPY	ETF	297.365	297.9	297.25	297.8416	2816713.0
2019-10-18 13:00:00	SPY	ETF	297.85	299.0496	297.82	298.24	3118187.0
2019-10-18 13:30:00	SPY	ETF	298.2306	298.67	298.14	298.57	2045616.0
2019-10-18 14:00:00	SPY	ETF	298.58	298.72	298.3	298.69	2187113.0
2019-10-18 14:30:00	SPY	ETF	298.6899	298.6961	298.35	298.62	2293753.0
2019-10-18 15:00:00	SPY	ETF	298.64	298.94	298.59	298.59	4683750.0
2019-10-18 15:30:00	SPY	ETF	298.595	298.8	297.98	297.98	9591401.0
2019-10-18 16:00:00	SPY	ETF	297.98	298.4656	297.95	298.3	8107213.0
2019-10-18 16:30:00	SPY	ETF	298.3	299.1942	297.97	298.38	543668.0
2019-10-18 17:00:00	SPY	ETF	298.38	298.4	298.16	298.21	331586.0
2019-10-18 17:30:00	SPY	ETF	298.25	298.3	297.97	298.0	1575464.0
2019-10-18 18:00:00	SPY	ETF	298.06	298.14	298.02	298.02	8173.0
2019-10-18 18:30:00	SPY	ETF	298.05	298.1	298.05	298.09	5508.0
2019-10-18 19:00:00	SPY	ETF	298.06	298.15	298.06	298.11	7955.0
2019-10-18 19:30:00	SPY	ETF	298.15	298.15	298.02	298.02	15018.0
2019-10-18 04:00:00	QQQ	ETF	193.2	193.3	193.17	193.19	2560.0
2019-10-18 04:30:00	QQQ	ETF	193.14	193.3	193.13	193.3	5580.0
2019-10-18 05:00:00	QQQ	ETF	193.23	193.4	193.19	193.35	7420.0
2019-10-18 05:30:00	QQQ	ETF	193.32	193.38	193.28	193.37	6500.0
2019-10-18 06:00:00	QQQ	ETF	193.35	193.37	193.33	193.37	2987.0
2019-10-18 06:30:00	QQQ	ETF	193.31	193.43	193.31	193.43	2100.0
2019-10-18 07:00:00	QQQ	ETF	193.45	193.53	193.43	193.46	77711.0
2019-10-18 07:30:00	QQQ	ETF	193.54	193.66	193.51	193.54	49347.0
2019-10-18 08:00:00	QQQ	ETF	193.47	193.65	193.0	193.56	112548.0
2019-10-18 08:30:00	QQQ	ETF	193.58	193.64	193.45	193.48	72314.0
2019-10-18 09:00:00	QQQ	ETF	193.4799	193.51	193.12	193.32	295692.0
2019-10-18 09:30:00	QQQ	ETF	193.32	193.67	193.2	193.48	1643010.0
2019-10-18 10:00:00	QQQ	ETF	193.48	193.49	192.77	192.9	1580868.0
2019-10-18 10:30:00	QQQ	ETF	192.91	192.91	192.2	192.59	1642488.0
2019-10-18 11:00:00	QQQ	ETF	192.58	192.7	192.33	192.51	816438.0
2019-10-18 11:30:00	QQQ	ETF	192.51	192.66	191.4	191.43	2120341.0
2019-10-18 12:00:00	QQQ	ETF	191.42	191.75	190.705	190.9151	2397283.0
2019-10-18 12:30:00	QQQ	ETF	190.91	191.55	190.8	191.455	1693960.0

> showing 50 of 16,956 rows — these rows as CSV

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