PREVIEW / etf_30min / 2019-08-23

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-23.parquet
  size:    527 KB
  rows:    18,431

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-08-23 04:00:00	SPY	ETF	293.14	293.42	293.1	293.42	6275.0
2019-08-23 04:30:00	SPY	ETF	293.42	293.5	293.34	293.39	4175.0
2019-08-23 05:00:00	SPY	ETF	293.35	293.48	293.35	293.48	1600.0
2019-08-23 05:30:00	SPY	ETF	293.28	293.31	293.14	293.29	5804.0
2019-08-23 06:00:00	SPY	ETF	293.28	293.29	293.1	293.1	7096.0
2019-08-23 06:30:00	SPY	ETF	292.9	292.9	292.7	292.85	9489.0
2019-08-23 07:00:00	SPY	ETF	292.89	293.07	292.86	293.05	80341.0
2019-08-23 07:30:00	SPY	ETF	293.05	293.45	292.92	293.19	222883.0
2019-08-23 08:00:00	SPY	ETF	292.98	293.57	290.25	290.58	2172614.0
2019-08-23 08:30:00	SPY	ETF	290.69	291.4	290.38	291.17	868626.0
2019-08-23 09:00:00	SPY	ETF	291.13	291.19	290.64	290.9	972599.0
2019-08-23 09:30:00	SPY	ETF	290.92	291.21	290.12	290.93	6072379.0
2019-08-23 10:00:00	SPY	ETF	290.92	292.0599	290.43	291.46	10740869.0
2019-08-23 10:30:00	SPY	ETF	291.49	292.76	291.29	291.8	6821844.0
2019-08-23 11:00:00	SPY	ETF	291.8	292.06	287.32	288.1187	19823337.0
2019-08-23 11:30:00	SPY	ETF	288.15	288.39	286.63	286.7	9448676.0
2019-08-23 12:00:00	SPY	ETF	286.71	287.645	286.37	286.86	7218462.0
2019-08-23 12:30:00	SPY	ETF	286.85	287.7	286.49	286.8035	5752581.0
2019-08-23 13:00:00	SPY	ETF	286.8	287.0	285.79	285.94	6291823.0
2019-08-23 13:30:00	SPY	ETF	285.9409	286.9	285.81	286.62	4658876.0
2019-08-23 14:00:00	SPY	ETF	286.62	286.62	286.01	286.22	3361032.0
2019-08-23 14:30:00	SPY	ETF	286.22	286.52	285.35	285.88	4618772.0
2019-08-23 15:00:00	SPY	ETF	285.88	286.3	285.16	285.225	6411905.0
2019-08-23 15:30:00	SPY	ETF	285.23	285.36	283.47	284.81	26589732.0
2019-08-23 16:00:00	SPY	ETF	284.82	292.749	284.7216	285.35	21770961.0
2019-08-23 16:30:00	SPY	ETF	285.35	285.5	284.74	285.11	974210.0
2019-08-23 17:00:00	SPY	ETF	285.17	285.17	283.33	284.86	1664599.0
2019-08-23 17:30:00	SPY	ETF	284.85	285.04	284.5	284.9	151913.0
2019-08-23 18:00:00	SPY	ETF	284.84	284.94	284.73	284.92	58791.0
2019-08-23 18:30:00	SPY	ETF	284.92	284.99	284.8	284.8	41733.0
2019-08-23 19:00:00	SPY	ETF	284.81	284.87	284.66	284.68	51850.0
2019-08-23 19:30:00	SPY	ETF	284.68	284.85	284.67	284.77	27991.0
2019-08-23 04:00:00	QQQ	ETF	188.74	189.0	188.68	188.99	3889.0
2019-08-23 04:30:00	QQQ	ETF	188.96	189.1	188.96	189.03	5000.0
2019-08-23 05:00:00	QQQ	ETF	188.97	189.04	188.82	188.87	8360.0
2019-08-23 05:30:00	QQQ	ETF	188.92	188.92	188.76	188.87	5110.0
2019-08-23 06:00:00	QQQ	ETF	188.86	188.9	188.77	188.77	5750.0
2019-08-23 06:30:00	QQQ	ETF	188.77	188.77	188.36	188.5	27070.0
2019-08-23 07:00:00	QQQ	ETF	188.54	188.64	188.5	188.61	71165.0
2019-08-23 07:30:00	QQQ	ETF	188.6	188.85	188.45	188.7	91222.0
2019-08-23 08:00:00	QQQ	ETF	188.52	189.1	186.21	186.6	1195739.0
2019-08-23 08:30:00	QQQ	ETF	186.63	187.12	186.39	186.97	228339.0
2019-08-23 09:00:00	QQQ	ETF	186.96	186.98	186.42	186.79	178495.0
2019-08-23 09:30:00	QQQ	ETF	186.78	187.04	185.94	186.57	3353381.0
2019-08-23 10:00:00	QQQ	ETF	186.58	187.6	186.25	187.28	4019767.0
2019-08-23 10:30:00	QQQ	ETF	187.28	188.45	187.11	187.63	3384249.0
2019-08-23 11:00:00	QQQ	ETF	187.64	187.86	184.12	184.61	7011352.0
2019-08-23 11:30:00	QQQ	ETF	184.62	184.79	183.38	183.39	3883545.0
2019-08-23 12:00:00	QQQ	ETF	183.39	183.99	183.15	183.41	2807908.0
2019-08-23 12:30:00	QQQ	ETF	183.41	184.04	183.21	183.55	2348907.0

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

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