PREVIEW / etf_30min / 2019-08-14

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-14.parquet
  size:    549 KB
  rows:    19,323

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-14 04:00:00	SPY	ETF	292.34	292.36	292.13	292.19	9245.0
2019-08-14 04:30:00	SPY	ETF	292.2	292.2	291.62	291.84	11777.0
2019-08-14 05:00:00	SPY	ETF	291.87	291.87	291.37	291.37	13577.0
2019-08-14 05:30:00	SPY	ETF	291.49	291.49	291.12	291.12	11963.0
2019-08-14 06:00:00	SPY	ETF	291.12	291.12	290.0	290.34	74410.0
2019-08-14 06:30:00	SPY	ETF	290.35	290.74	290.2	290.34	97863.0
2019-08-14 07:00:00	SPY	ETF	290.4	290.54	290.05	290.47	229220.0
2019-08-14 07:30:00	SPY	ETF	290.42	290.47	288.76	289.11	778388.0
2019-08-14 08:00:00	SPY	ETF	290.43	293.0	288.42	289.07	1457577.0
2019-08-14 08:30:00	SPY	ETF	289.1	290.4	288.47	289.16	1197904.0
2019-08-14 09:00:00	SPY	ETF	289.18	292.55	287.77	288.06	1178511.0
2019-08-14 09:30:00	SPY	ETF	288.07	288.74	287.38	288.31	12804960.0
2019-08-14 10:00:00	SPY	ETF	288.29	288.31	287.16	287.92	7780238.0
2019-08-14 10:30:00	SPY	ETF	287.91	288.03	286.58	286.61	5771153.0
2019-08-14 11:00:00	SPY	ETF	286.595	292.4644	285.44	286.11	8200545.0
2019-08-14 11:30:00	SPY	ETF	286.12	286.56	285.41	285.7	4575665.0
2019-08-14 12:00:00	SPY	ETF	285.7	285.705	284.92	285.24	6162546.0
2019-08-14 12:30:00	SPY	ETF	285.2314	285.76	284.22	284.38	6118348.0
2019-08-14 13:00:00	SPY	ETF	284.38	285.93	283.97	285.35	9326120.0
2019-08-14 13:30:00	SPY	ETF	285.36	292.4644	285.3	285.5199	4810843.0
2019-08-14 14:00:00	SPY	ETF	285.52	285.71	284.87	284.93	5035567.0
2019-08-14 14:30:00	SPY	ETF	284.93	285.18	284.0	284.55	6358388.0
2019-08-14 15:00:00	SPY	ETF	284.54	285.61	283.76	284.64	11091948.0
2019-08-14 15:30:00	SPY	ETF	284.64	284.86	283.78	283.92	26370352.0
2019-08-14 16:00:00	SPY	ETF	283.92	284.7731	283.61	283.91	10990065.0
2019-08-14 16:30:00	SPY	ETF	283.93	292.4644	283.47	283.49	1360020.0
2019-08-14 17:00:00	SPY	ETF	283.51	283.65	283.41	283.44	200986.0
2019-08-14 17:30:00	SPY	ETF	283.44	283.75	283.41	283.55	196902.0
2019-08-14 18:00:00	SPY	ETF	283.51	283.91	283.28	283.68	325425.0
2019-08-14 18:30:00	SPY	ETF	283.71	283.91	283.4	283.45	202159.0
2019-08-14 19:00:00	SPY	ETF	283.54	283.84	283.42	283.79	35111.0
2019-08-14 19:30:00	SPY	ETF	283.85	284.53	283.85	284.47	125413.0
2019-08-14 04:00:00	QQQ	ETF	188.22	188.33	188.13	188.33	11081.0
2019-08-14 04:30:00	QQQ	ETF	188.2	188.24	187.75	187.83	17702.0
2019-08-14 05:00:00	QQQ	ETF	187.85	187.85	187.45	187.53	7864.0
2019-08-14 05:30:00	QQQ	ETF	187.55	187.55	187.25	187.36	9413.0
2019-08-14 06:00:00	QQQ	ETF	187.33	187.36	186.47	186.75	39748.0
2019-08-14 06:30:00	QQQ	ETF	186.7	186.97	186.69	186.8	23202.0
2019-08-14 07:00:00	QQQ	ETF	186.89	187.0	186.69	186.96	148217.0
2019-08-14 07:30:00	QQQ	ETF	186.93	186.98	185.75	185.99	232524.0
2019-08-14 08:00:00	QQQ	ETF	186.34	188.79	185.4	185.82	333478.0
2019-08-14 08:30:00	QQQ	ETF	185.89	186.04	185.44	185.95	216459.0
2019-08-14 09:00:00	QQQ	ETF	186.0	188.39	185.04	185.32	533793.0
2019-08-14 09:30:00	QQQ	ETF	185.31	185.95	184.79	185.62	5520795.0
2019-08-14 10:00:00	QQQ	ETF	185.6	185.64	184.64	185.1368	3225200.0
2019-08-14 10:30:00	QQQ	ETF	185.13	185.22	184.21	184.21	2432428.0
2019-08-14 11:00:00	QQQ	ETF	184.21	184.38	183.47	183.9065	3724810.0
2019-08-14 11:30:00	QQQ	ETF	183.91	184.225	183.18	183.36	2647559.0
2019-08-14 12:00:00	QQQ	ETF	183.34	183.345	182.79	183.1	2419405.0
2019-08-14 12:30:00	QQQ	ETF	183.0959	183.5127	182.5499	182.68	2589123.0

> showing 50 of 19,323 rows — these rows as CSV

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