PREVIEW / etf_30min / 2019-12-04

all etf 30-min files

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

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-04 04:00:00	SPY	ETF	309.14	310.98	309.14	310.67	18728.0
2019-12-04 04:30:00	SPY	ETF	310.75	310.85	310.14	310.85	64519.0
2019-12-04 05:00:00	SPY	ETF	310.74	310.74	310.5	310.61	15110.0
2019-12-04 05:30:00	SPY	ETF	310.66	310.76	310.42	310.46	14370.0
2019-12-04 06:00:00	SPY	ETF	310.4	310.68	310.4	310.59	22182.0
2019-12-04 06:30:00	SPY	ETF	310.6	310.82	310.55	310.79	30658.0
2019-12-04 07:00:00	SPY	ETF	310.82	310.95	310.67	310.93	137523.0
2019-12-04 07:30:00	SPY	ETF	310.879	310.88	310.65	310.75	48715.0
2019-12-04 08:00:00	SPY	ETF	308.74	310.9	308.48	310.5802	551988.0
2019-12-04 08:30:00	SPY	ETF	310.58	310.67	310.3	310.61	161647.0
2019-12-04 09:00:00	SPY	ETF	310.61	310.89	310.56	310.68	988487.0
2019-12-04 09:30:00	SPY	ETF	310.7	311.825	310.32	311.67	8013420.0
2019-12-04 10:00:00	SPY	ETF	311.65	311.94	311.43	311.47	4419408.0
2019-12-04 10:30:00	SPY	ETF	311.47	311.87	311.36	311.8	2855720.0
2019-12-04 11:00:00	SPY	ETF	311.8	311.88	311.44	311.65	2552613.0
2019-12-04 11:30:00	SPY	ETF	311.65	311.97	311.58	311.59	2824490.0
2019-12-04 12:00:00	SPY	ETF	311.59	311.68	311.3144	311.43	2126078.0
2019-12-04 12:30:00	SPY	ETF	311.43	311.71	311.36	311.675	1252450.0
2019-12-04 13:00:00	SPY	ETF	311.675	311.71	311.44	311.67	1066281.0
2019-12-04 13:30:00	SPY	ETF	311.66	311.68	311.49	311.68	779312.0
2019-12-04 14:00:00	SPY	ETF	311.68	312.0	311.66	312.0	2767389.0
2019-12-04 14:30:00	SPY	ETF	311.99	312.12	311.9	312.03	2200252.0
2019-12-04 15:00:00	SPY	ETF	312.03	312.06	311.69	311.7	2385055.0
2019-12-04 15:30:00	SPY	ETF	311.71	311.92	311.37	311.47	6196504.0
2019-12-04 16:00:00	SPY	ETF	311.46	311.53	311.0	311.28	6036531.0
2019-12-04 16:30:00	SPY	ETF	311.29	311.31	309.4744	311.28	386259.0
2019-12-04 17:00:00	SPY	ETF	311.24	311.33	311.21	311.27	103918.0
2019-12-04 17:30:00	SPY	ETF	311.3	311.32	311.26	311.31	48418.0
2019-12-04 18:00:00	SPY	ETF	311.3	311.46	311.23	311.41	95076.0
2019-12-04 18:30:00	SPY	ETF	311.42	311.42	311.16	311.18	30532.0
2019-12-04 19:00:00	SPY	ETF	311.15	311.32	311.15	311.2	8407.0
2019-12-04 19:30:00	SPY	ETF	311.18	311.23	311.05	311.18	40609.0
2019-12-04 04:00:00	QQQ	ETF	201.12	202.8	201.12	202.49	42884.0
2019-12-04 04:30:00	QQQ	ETF	202.53	202.6	202.08	202.57	24187.0
2019-12-04 05:00:00	QQQ	ETF	202.57	202.57	202.31	202.37	19160.0
2019-12-04 05:30:00	QQQ	ETF	202.51	202.51	202.29	202.32	8585.0
2019-12-04 06:00:00	QQQ	ETF	202.3	202.47	202.3	202.44	9030.0
2019-12-04 06:30:00	QQQ	ETF	202.45	202.59	202.41	202.52	25480.0
2019-12-04 07:00:00	QQQ	ETF	202.55	202.66	202.43	202.66	44635.0
2019-12-04 07:30:00	QQQ	ETF	202.6	202.6	202.39	202.47	60069.0
2019-12-04 08:00:00	QQQ	ETF	202.46	202.61	200.64	202.29	240783.0
2019-12-04 08:30:00	QQQ	ETF	202.28	202.42	202.07	202.3702	68252.0
2019-12-04 09:00:00	QQQ	ETF	202.37	202.65	202.31	202.48	66861.0
2019-12-04 09:30:00	QQQ	ETF	202.49	202.8724	202.14	202.73	2652429.0
2019-12-04 10:00:00	QQQ	ETF	202.73	202.91	202.49	202.49	1355013.0
2019-12-04 10:30:00	QQQ	ETF	202.5	202.795	202.42	202.76	512729.0
2019-12-04 11:00:00	QQQ	ETF	202.77	202.85	202.49	202.68	627867.0
2019-12-04 11:30:00	QQQ	ETF	202.69	202.91	202.49	202.5353	501772.0
2019-12-04 12:00:00	QQQ	ETF	202.53	202.63	202.31	202.4252	698654.0
2019-12-04 12:30:00	QQQ	ETF	202.43	202.65	202.4	202.5879	507698.0

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

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