PREVIEW / etf_30min / 2018-01-30

all etf 30-min files

  file:    by_date/etf_30min/2018/2018-01-30.parquet
  size:    509 KB
  rows:    17,633

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
2018-01-30 04:00:00	SPY	ETF	283.68	283.78	283.31	283.73	4729.0
2018-01-30 04:30:00	SPY	ETF	283.75	283.84	283.58	283.79	11345.0
2018-01-30 05:00:00	SPY	ETF	283.89	283.89	283.52	283.52	117950.0
2018-01-30 05:30:00	SPY	ETF	283.51	283.57	283.42	283.47	6806.0
2018-01-30 06:00:00	SPY	ETF	283.4	283.61	283.34	283.46	76456.0
2018-01-30 06:30:00	SPY	ETF	283.46	283.55	283.41	283.41	57215.0
2018-01-30 07:00:00	SPY	ETF	283.45	283.5	283.33	283.42	48346.0
2018-01-30 07:30:00	SPY	ETF	283.43	283.45	282.91	283.32	204087.0
2018-01-30 08:00:00	SPY	ETF	283.32	283.62	282.99	283.24	790257.0
2018-01-30 08:30:00	SPY	ETF	283.25	283.33	282.81	282.87	832718.0
2018-01-30 09:00:00	SPY	ETF	282.85	282.88	282.29	282.61	2048084.0
2018-01-30 09:30:00	SPY	ETF	282.6	283.29	281.92	281.99	20012536.0
2018-01-30 10:00:00	SPY	ETF	281.99	282.27	281.22	282.25	12796145.0
2018-01-30 10:30:00	SPY	ETF	282.25	282.8464	282.02	282.721	9165495.0
2018-01-30 11:00:00	SPY	ETF	282.73	284.736	282.17	282.275	12622106.0
2018-01-30 11:30:00	SPY	ETF	282.27	282.77	281.9	281.96	4481677.0
2018-01-30 12:00:00	SPY	ETF	281.97	282.22	281.79	281.86	3921951.0
2018-01-30 12:30:00	SPY	ETF	281.86	282.09	281.64	281.89	6052873.0
2018-01-30 13:00:00	SPY	ETF	281.88	281.89	281.37	281.48	5778409.0
2018-01-30 13:30:00	SPY	ETF	281.475	282.36	281.44	282.13	4306924.0
2018-01-30 14:00:00	SPY	ETF	282.13	282.52	281.96	282.1099	4713144.0
2018-01-30 14:30:00	SPY	ETF	282.105	282.12	281.52	281.64	6076267.0
2018-01-30 15:00:00	SPY	ETF	281.64	282.17	281.53	282.0801	4187586.0
2018-01-30 15:30:00	SPY	ETF	282.08	282.45	281.58	281.66	16427670.0
2018-01-30 16:00:00	SPY	ETF	281.65	282.1	281.55	281.79	11134115.0
2018-01-30 16:30:00	SPY	ETF	281.79	282.5	281.45	281.65	1424382.0
2018-01-30 17:00:00	SPY	ETF	281.65	281.67	281.5	281.52	153542.0
2018-01-30 17:30:00	SPY	ETF	281.55	281.76	281.52	281.59	3037401.0
2018-01-30 18:00:00	SPY	ETF	281.63	281.9	281.56	281.89	133954.0
2018-01-30 18:30:00	SPY	ETF	281.87	281.9	281.73	281.76	40309.0
2018-01-30 19:00:00	SPY	ETF	281.76	282.03	281.76	282.0	52764.0
2018-01-30 19:30:00	SPY	ETF	281.99	282.06	281.7	281.72	55277.0
2018-01-30 04:00:00	QQQ	ETF	169.42	169.42	169.25	169.3	8504.0
2018-01-30 04:30:00	QQQ	ETF	169.25	169.42	169.25	169.39	4300.0
2018-01-30 05:00:00	QQQ	ETF	169.46	169.46	169.25	169.25	4387.0
2018-01-30 05:30:00	QQQ	ETF	169.27	169.29	169.21	169.21	26834.0
2018-01-30 06:00:00	QQQ	ETF	169.22	169.36	169.2	169.29	22011.0
2018-01-30 06:30:00	QQQ	ETF	169.29	169.36	169.21	169.21	25350.0
2018-01-30 07:00:00	QQQ	ETF	169.23	169.42	169.23	169.42	109126.0
2018-01-30 07:30:00	QQQ	ETF	169.38	169.38	169.07	169.21	336929.0
2018-01-30 08:00:00	QQQ	ETF	169.23	169.34	169.05	169.09	412791.0
2018-01-30 08:30:00	QQQ	ETF	169.09	169.17	168.77	168.78	347866.0
2018-01-30 09:00:00	QQQ	ETF	168.78	168.85	168.44	168.6	635106.0
2018-01-30 09:30:00	QQQ	ETF	168.59	168.97	168.09	168.21	6024455.0
2018-01-30 10:00:00	QQQ	ETF	168.2	168.67	167.82	168.665	3479948.0
2018-01-30 10:30:00	QQQ	ETF	168.66	169.12	168.36	169.07	3688393.0
2018-01-30 11:00:00	QQQ	ETF	169.08	169.42	168.93	169.03	2881901.0
2018-01-30 11:30:00	QQQ	ETF	169.04	169.22	168.66	168.715	1790171.0
2018-01-30 12:00:00	QQQ	ETF	168.72	168.93	168.6	168.68	1221359.0
2018-01-30 12:30:00	QQQ	ETF	168.685	168.8	168.37	168.56	1509791.0

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

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