PREVIEW / etf_30min / 2020-02-25

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-02-25.parquet
  size:    607 KB
  rows:    21,547

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
2020-02-25 04:00:00	SPY	ETF	324.2	324.57	323.35	323.68	67216.0
2020-02-25 04:30:00	SPY	ETF	323.52	323.77	323.33	323.33	15812.0
2020-02-25 05:00:00	SPY	ETF	323.35	323.55	322.82	322.88	33835.0
2020-02-25 05:30:00	SPY	ETF	322.8	323.01	321.92	322.85	88441.0
2020-02-25 06:00:00	SPY	ETF	322.69	322.9	322.41	322.9	39294.0
2020-02-25 06:30:00	SPY	ETF	322.9	323.75	322.77	323.23	183944.0
2020-02-25 07:00:00	SPY	ETF	323.23	323.9	322.8	323.46	322728.0
2020-02-25 07:30:00	SPY	ETF	323.42	324.34	323.3	324.18	243426.0
2020-02-25 08:00:00	SPY	ETF	324.19	325.53	322.42	323.68	574065.0
2020-02-25 08:30:00	SPY	ETF	323.67	324.38	323.44	324.05	1055833.0
2020-02-25 09:00:00	SPY	ETF	324.05	324.13	323.56	323.97	490401.0
2020-02-25 09:30:00	SPY	ETF	323.94	324.61	322.04	323.14	13270398.0
2020-02-25 10:00:00	SPY	ETF	323.12	323.57	319.98	320.26	11864436.0
2020-02-25 10:30:00	SPY	ETF	320.27	321.27	318.45	319.82	14893642.0
2020-02-25 11:00:00	SPY	ETF	319.82	320.235	317.53	318.75	12586483.0
2020-02-25 11:30:00	SPY	ETF	318.755	319.74	318.25	319.42	7531923.0
2020-02-25 12:00:00	SPY	ETF	319.42	319.68	317.93	318.175	6701060.0
2020-02-25 12:30:00	SPY	ETF	318.14	319.07	316.97	317.09	7727525.0
2020-02-25 13:00:00	SPY	ETF	317.08	317.74	316.17	316.6	10385033.0
2020-02-25 13:30:00	SPY	ETF	316.6	316.68	315.05	315.085	10393528.0
2020-02-25 14:00:00	SPY	ETF	315.09	315.23	312.55	312.61	25084516.0
2020-02-25 14:30:00	SPY	ETF	312.605	314.68	312.08	314.16	21815859.0
2020-02-25 15:00:00	SPY	ETF	314.18	322.4158	312.46	313.15	18754272.0
2020-02-25 15:30:00	SPY	ETF	313.145	314.07	311.69	312.7	32662549.0
2020-02-25 16:00:00	SPY	ETF	312.69	322.4158	312.39	313.09	11157892.0
2020-02-25 16:30:00	SPY	ETF	313.13	314.31	312.59	313.73	1060288.0
2020-02-25 17:00:00	SPY	ETF	313.58	313.85	312.65	312.97	4112942.0
2020-02-25 17:30:00	SPY	ETF	312.98	313.25	312.92	313.14	221730.0
2020-02-25 18:00:00	SPY	ETF	313.2	314.68	313.2	314.61	373497.0
2020-02-25 18:30:00	SPY	ETF	314.6	315.21	314.31	315.0	604023.0
2020-02-25 19:00:00	SPY	ETF	315.03	315.12	314.0	314.72	192537.0
2020-02-25 19:30:00	SPY	ETF	314.66	314.68	313.38	313.43	149711.0
2020-02-25 04:00:00	QQQ	ETF	223.15	223.65	222.58	222.74	53081.0
2020-02-25 04:30:00	QQQ	ETF	222.78	223.04	222.5	222.5	16202.0
2020-02-25 05:00:00	QQQ	ETF	222.5	222.82	222.0	222.16	61430.0
2020-02-25 05:30:00	QQQ	ETF	222.02	222.1	221.1	222.0	99164.0
2020-02-25 06:00:00	QQQ	ETF	221.7	221.99	221.53	221.97	42029.0
2020-02-25 06:30:00	QQQ	ETF	221.99	222.85	221.93	222.53	144683.0
2020-02-25 07:00:00	QQQ	ETF	222.53	223.14	222.2	222.77	224667.0
2020-02-25 07:30:00	QQQ	ETF	222.72	223.66	222.6	223.51	196563.0
2020-02-25 08:00:00	QQQ	ETF	222.5801	224.68	221.39	223.01	344203.0
2020-02-25 08:30:00	QQQ	ETF	223.02	223.64	222.81	223.39	382184.0
2020-02-25 09:00:00	QQQ	ETF	223.34	223.42	222.92	223.2	290043.0
2020-02-25 09:30:00	QQQ	ETF	223.19	223.9879	221.63	222.53	7298296.0
2020-02-25 10:00:00	QQQ	ETF	222.52	222.89	220.28	220.61	5221502.0
2020-02-25 10:30:00	QQQ	ETF	220.61	221.27	218.97	220.02	7393602.0
2020-02-25 11:00:00	QQQ	ETF	219.98	220.25	217.92	219.04	7126921.0
2020-02-25 11:30:00	QQQ	ETF	219.04	220.42	218.595	220.18	6006505.0
2020-02-25 12:00:00	QQQ	ETF	220.18	220.51	219.0	219.29	3062929.0
2020-02-25 12:30:00	QQQ	ETF	219.28	220.04	218.4552	218.61	2905541.0

> showing 50 of 21,547 rows — these rows as CSV

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