PREVIEW / etf_30min / 2019-08-05

all etf 30-min files

  file:    by_date/etf_30min/2019/2019-08-05.parquet
  size:    572 KB
  rows:    20,297

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-05 04:00:00	SPY	ETF	289.7	289.7	288.85	288.85	34173.0
2019-08-05 04:30:00	SPY	ETF	288.8	289.18	288.6	288.63	16353.0
2019-08-05 05:00:00	SPY	ETF	288.5	289.3	288.31	288.98	51968.0
2019-08-05 05:30:00	SPY	ETF	289.08	289.75	289.08	289.5	69825.0
2019-08-05 06:00:00	SPY	ETF	289.5	289.66	289.0	289.05	85034.0
2019-08-05 06:30:00	SPY	ETF	289.04	289.1	288.85	288.93	75490.0
2019-08-05 07:00:00	SPY	ETF	288.93	288.98	288.24	288.29	315271.0
2019-08-05 07:30:00	SPY	ETF	288.3	289.19	288.3	289.01	390947.0
2019-08-05 08:00:00	SPY	ETF	289.04	292.62	288.28	288.69	528606.0
2019-08-05 08:30:00	SPY	ETF	288.66	288.74	288.14	288.23	992070.0
2019-08-05 09:00:00	SPY	ETF	288.23	288.43	287.97	288.07	972217.0
2019-08-05 09:30:00	SPY	ETF	288.09	288.21	286.71	287.302	16704900.0
2019-08-05 10:00:00	SPY	ETF	287.29	287.42	286.36	286.67	10022956.0
2019-08-05 10:30:00	SPY	ETF	286.65	286.83	285.73	286.41	9001555.0
2019-08-05 11:00:00	SPY	ETF	286.42	287.34	286.25	286.6	8567836.0
2019-08-05 11:30:00	SPY	ETF	286.59	286.68	286.07	286.1	6968901.0
2019-08-05 12:00:00	SPY	ETF	286.1	286.32	285.38	285.47	6673912.0
2019-08-05 12:30:00	SPY	ETF	285.485	285.77	284.22	284.32	7932972.0
2019-08-05 13:00:00	SPY	ETF	284.33	285.36	284.17	284.88	6671990.0
2019-08-05 13:30:00	SPY	ETF	284.88	285.51	284.1	284.1317	6197662.0
2019-08-05 14:00:00	SPY	ETF	284.135	284.4796	283.33	283.3525	7836101.0
2019-08-05 14:30:00	SPY	ETF	283.35	283.65	282.6	282.79	11987079.0
2019-08-05 15:00:00	SPY	ETF	282.78	284.21	281.72	283.3	19450715.0
2019-08-05 15:30:00	SPY	ETF	283.28	284.79	282.79	284.04	31153726.0
2019-08-05 16:00:00	SPY	ETF	284.03	284.19	282.45	282.69	16913291.0
2019-08-05 16:30:00	SPY	ETF	282.69	292.7433	281.94	282.18	2424421.0
2019-08-05 17:00:00	SPY	ETF	282.18	283.82	282.14	282.32	257456.0
2019-08-05 17:30:00	SPY	ETF	282.34	282.43	281.09	281.4	187571.0
2019-08-05 18:00:00	SPY	ETF	281.4	281.48	278.0	279.39	1108304.0
2019-08-05 18:30:00	SPY	ETF	279.37	279.82	278.42	278.5399	462138.0
2019-08-05 19:00:00	SPY	ETF	278.5	279.21	278.4	279.14	142573.0
2019-08-05 19:30:00	SPY	ETF	279.0	279.03	277.37	277.94	372839.0
2019-08-05 04:00:00	QQQ	ETF	184.91	184.91	184.2	184.27	37895.0
2019-08-05 04:30:00	QQQ	ETF	184.23	184.6	184.04	184.05	20930.0
2019-08-05 05:00:00	QQQ	ETF	184.07	184.53	183.82	184.25	34076.0
2019-08-05 05:30:00	QQQ	ETF	184.3	184.89	184.27	184.64	88436.0
2019-08-05 06:00:00	QQQ	ETF	184.59	184.75	184.28	184.31	41496.0
2019-08-05 06:30:00	QQQ	ETF	184.32	184.34	184.18	184.33	45164.0
2019-08-05 07:00:00	QQQ	ETF	184.27	184.34	183.66	183.71	117888.0
2019-08-05 07:30:00	QQQ	ETF	183.81	184.3	183.81	184.17	142404.0
2019-08-05 08:00:00	QQQ	ETF	184.05	185.0	183.55	183.86	326387.0
2019-08-05 08:30:00	QQQ	ETF	183.81	183.87	183.35	183.46	333244.0
2019-08-05 09:00:00	QQQ	ETF	183.42	183.7701	183.28	183.52	1245798.0
2019-08-05 09:30:00	QQQ	ETF	183.51	183.51	182.1	182.87	9396264.0
2019-08-05 10:00:00	QQQ	ETF	182.87	183.0	182.14	182.44	4252044.0
2019-08-05 10:30:00	QQQ	ETF	182.4399	182.55	181.61	182.13	4106084.0
2019-08-05 11:00:00	QQQ	ETF	182.13	182.85	181.94	182.11	3578089.0
2019-08-05 11:30:00	QQQ	ETF	182.11	182.19	181.74	181.8	2291839.0
2019-08-05 12:00:00	QQQ	ETF	181.7793	181.97	181.394	181.45	3300463.0
2019-08-05 12:30:00	QQQ	ETF	181.4365	181.71	180.55	180.63	3716479.0

> showing 50 of 20,297 rows — these rows as CSV

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