PREVIEW / etf_30min / 2019-06-05

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-06-05.parquet
  size:    504 KB
  rows:    17,664

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-06-05 04:00:00	SPY	ETF	281.69	281.75	281.62	281.67	15502.0
2019-06-05 04:30:00	SPY	ETF	281.64	281.68	281.64	281.68	1610.0
2019-06-05 05:00:00	SPY	ETF	281.55	282.28	281.49	282.21	28322.0
2019-06-05 05:30:00	SPY	ETF	282.26	282.46	282.21	282.45	51536.0
2019-06-05 06:00:00	SPY	ETF	282.45	282.63	282.35	282.51	71637.0
2019-06-05 06:30:00	SPY	ETF	282.46	282.64	282.23	282.6	72934.0
2019-06-05 07:00:00	SPY	ETF	282.62	282.64	282.15	282.15	159695.0
2019-06-05 07:30:00	SPY	ETF	282.12	282.3	282.0	282.25	283756.0
2019-06-05 08:00:00	SPY	ETF	282.6101	282.63	280.53	281.46	993652.0
2019-06-05 08:30:00	SPY	ETF	281.46	281.63	281.27	281.53	449141.0
2019-06-05 09:00:00	SPY	ETF	281.53	282.36	281.47	282.32	604274.0
2019-06-05 09:30:00	SPY	ETF	282.33	282.39	281.08	281.8175	8176646.0
2019-06-05 10:00:00	SPY	ETF	281.82	282.09	281.07	281.13	5058037.0
2019-06-05 10:30:00	SPY	ETF	281.14	281.24	280.32	280.8249	6169711.0
2019-06-05 11:00:00	SPY	ETF	280.83	281.8	280.66	281.7301	3964677.0
2019-06-05 11:30:00	SPY	ETF	281.735	281.91	281.42	281.875	3964408.0
2019-06-05 12:00:00	SPY	ETF	281.88	282.07	281.38	282.0	4033784.0
2019-06-05 12:30:00	SPY	ETF	282.0	282.24	281.45	281.98	3616262.0
2019-06-05 13:00:00	SPY	ETF	281.97	282.58	281.97	282.47	3039715.0
2019-06-05 13:30:00	SPY	ETF	282.465	282.65	282.25	282.4884	3338440.0
2019-06-05 14:00:00	SPY	ETF	282.48	282.74	282.26	282.46	2143552.0
2019-06-05 14:30:00	SPY	ETF	282.46	282.64	282.11	282.255	3438958.0
2019-06-05 15:00:00	SPY	ETF	282.25	282.58	282.16	282.3941	2685611.0
2019-06-05 15:30:00	SPY	ETF	282.4	282.99	281.75	282.9	11525334.0
2019-06-05 16:00:00	SPY	ETF	282.9	283.0	280.5743	282.97	4472243.0
2019-06-05 16:30:00	SPY	ETF	282.96	283.16	282.96	283.0	623168.0
2019-06-05 17:00:00	SPY	ETF	282.99	283.09	282.83	282.86	128784.0
2019-06-05 17:30:00	SPY	ETF	282.85	282.97	282.32	282.35	289072.0
2019-06-05 18:00:00	SPY	ETF	282.33	282.38	281.8	281.8	328048.0
2019-06-05 18:30:00	SPY	ETF	281.81	282.23	281.51	282.1	140978.0
2019-06-05 19:00:00	SPY	ETF	282.04	282.19	281.96	282.13	38458.0
2019-06-05 19:30:00	SPY	ETF	282.12	282.49	282.12	282.38	72083.0
2019-06-05 04:00:00	QQQ	ETF	175.93	176.01	175.85	175.93	6577.0
2019-06-05 04:30:00	QQQ	ETF	175.95	175.99	175.78	175.81	17666.0
2019-06-05 05:00:00	QQQ	ETF	175.72	176.33	175.7	176.31	17896.0
2019-06-05 05:30:00	QQQ	ETF	176.32	176.52	176.32	176.49	24010.0
2019-06-05 06:00:00	QQQ	ETF	176.47	176.7	176.43	176.47	10228.0
2019-06-05 06:30:00	QQQ	ETF	176.51	176.64	176.44	176.56	9461.0
2019-06-05 07:00:00	QQQ	ETF	176.58	176.65	176.22	176.22	94131.0
2019-06-05 07:30:00	QQQ	ETF	176.26	176.38	176.14	176.33	63958.0
2019-06-05 08:00:00	QQQ	ETF	176.28	176.6399	174.91	175.85	429792.0
2019-06-05 08:30:00	QQQ	ETF	175.86	176.1	175.75	176.03	225064.0
2019-06-05 09:00:00	QQQ	ETF	175.98	176.59	175.98	176.57	535335.0
2019-06-05 09:30:00	QQQ	ETF	176.6	176.61	175.2871	175.85	5139187.0
2019-06-05 10:00:00	QQQ	ETF	175.86	176.15	174.94	174.99	2956318.0
2019-06-05 10:30:00	QQQ	ETF	174.99	175.17	174.38	174.79	3652025.0
2019-06-05 11:00:00	QQQ	ETF	174.8	175.76	174.63	175.7317	3308401.0
2019-06-05 11:30:00	QQQ	ETF	175.735	175.89	175.43	175.84	1526090.0
2019-06-05 12:00:00	QQQ	ETF	175.84	175.99	175.22	175.67	1335538.0
2019-06-05 12:30:00	QQQ	ETF	175.66	175.76	175.25	175.485	1178220.0

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

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