PREVIEW / etf_30min / 2019-01-10

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-01-10.parquet
  size:    500 KB
  rows:    17,457

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-01-10 04:00:00	SPY	ETF	255.92	256.16	255.74	256.16	35801.0
2019-01-10 04:30:00	SPY	ETF	256.13	256.3	256.0	256.0	15788.0
2019-01-10 05:00:00	SPY	ETF	256.06	256.57	256.06	256.21	22091.0
2019-01-10 05:30:00	SPY	ETF	256.2	256.5	255.89	256.0	54872.0
2019-01-10 06:00:00	SPY	ETF	256.08	256.25	255.9	256.08	10007.0
2019-01-10 06:30:00	SPY	ETF	256.13	256.25	256.04	256.19	36344.0
2019-01-10 07:00:00	SPY	ETF	256.16	256.52	256.16	256.3	64653.0
2019-01-10 07:30:00	SPY	ETF	256.33	256.58	256.0	256.45	84028.0
2019-01-10 08:00:00	SPY	ETF	256.32	256.74	255.46	256.55	464569.0
2019-01-10 08:30:00	SPY	ETF	256.56	256.75	256.14	256.24	270149.0
2019-01-10 09:00:00	SPY	ETF	256.22	256.47	256.2	256.31	249675.0
2019-01-10 09:30:00	SPY	ETF	256.26	256.49	255.5	255.9227	8393599.0
2019-01-10 10:00:00	SPY	ETF	255.93	257.19	255.73	257.12	6390513.0
2019-01-10 10:30:00	SPY	ETF	257.12	257.6	256.9	257.55	6980728.0
2019-01-10 11:00:00	SPY	ETF	257.55	258.05	257.37	257.59	7608043.0
2019-01-10 11:30:00	SPY	ETF	257.6	258.33	257.6	258.14	4410413.0
2019-01-10 12:00:00	SPY	ETF	258.135	258.42	257.67	258.08	3117816.0
2019-01-10 12:30:00	SPY	ETF	258.09	258.69	257.74	258.2701	4638524.0
2019-01-10 13:00:00	SPY	ETF	258.28	258.32	256.89	257.46	6050470.0
2019-01-10 13:30:00	SPY	ETF	257.46	257.53	256.66	257.445	5448323.0
2019-01-10 14:00:00	SPY	ETF	257.44	258.84	257.419	258.385	9041562.0
2019-01-10 14:30:00	SPY	ETF	258.38	258.64	257.83	258.28	5741906.0
2019-01-10 15:00:00	SPY	ETF	258.28	258.709	258.12	258.63	4320823.0
2019-01-10 15:30:00	SPY	ETF	258.62	259.16	258.43	258.96	15316116.0
2019-01-10 16:00:00	SPY	ETF	258.94	259.21	256.25	258.68	6217388.0
2019-01-10 16:30:00	SPY	ETF	258.68	258.88	258.63	258.77	231975.0
2019-01-10 17:00:00	SPY	ETF	258.74	258.83	258.7	258.72	67889.0
2019-01-10 17:30:00	SPY	ETF	258.72	258.88	258.66	258.72	40842.0
2019-01-10 18:00:00	SPY	ETF	258.71	258.71	258.44	258.52	92483.0
2019-01-10 18:30:00	SPY	ETF	258.51	258.52	258.26	258.46	131549.0
2019-01-10 19:00:00	SPY	ETF	258.44	258.88	258.44	258.85	64070.0
2019-01-10 19:30:00	SPY	ETF	258.8	258.92	258.52	258.57	51158.0
2019-01-10 04:00:00	QQQ	ETF	159.42	159.56	159.21	159.54	26190.0
2019-01-10 04:30:00	QQQ	ETF	159.55	159.67	159.46	159.48	18054.0
2019-01-10 05:00:00	QQQ	ETF	159.47	159.83	159.47	159.64	26298.0
2019-01-10 05:30:00	QQQ	ETF	159.53	159.73	159.4	159.4	27280.0
2019-01-10 06:00:00	QQQ	ETF	159.5	159.62	159.44	159.49	12800.0
2019-01-10 06:30:00	QQQ	ETF	159.49	159.65	159.49	159.6	4711.0
2019-01-10 07:00:00	QQQ	ETF	159.6	159.82	159.59	159.67	78892.0
2019-01-10 07:30:00	QQQ	ETF	159.66	159.74	159.35	159.68	102912.0
2019-01-10 08:00:00	QQQ	ETF	159.69	160.82	159.05	159.75	81762.0
2019-01-10 08:30:00	QQQ	ETF	159.73	159.89	159.52	159.6	133101.0
2019-01-10 09:00:00	QQQ	ETF	159.59	159.72	159.54	159.6	129730.0
2019-01-10 09:30:00	QQQ	ETF	159.59	159.72	158.7	159.0	4328367.0
2019-01-10 10:00:00	QQQ	ETF	158.9915	160.13	158.9201	160.08	3412195.0
2019-01-10 10:30:00	QQQ	ETF	160.09	160.5	159.86	160.39	2508810.0
2019-01-10 11:00:00	QQQ	ETF	160.4	160.59	160.06	160.15	1742475.0
2019-01-10 11:30:00	QQQ	ETF	160.16	160.69	160.16	160.59	1567002.0
2019-01-10 12:00:00	QQQ	ETF	160.58	160.7985	160.28	160.59	1408447.0
2019-01-10 12:30:00	QQQ	ETF	160.6	161.14	160.421	160.89	2123410.0

> showing 50 of 17,457 rows — these rows as CSV

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