PREVIEW / etf_30min / 2020-07-23

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-07-23.parquet
  size:    555 KB
  rows:    20,732

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-07-23 04:00:00	SPY	ETF	328.15	328.51	328.01	328.43	17820.0
2020-07-23 04:30:00	SPY	ETF	328.39	328.46	327.57	327.57	11682.0
2020-07-23 05:00:00	SPY	ETF	327.56	327.94	327.56	327.94	5693.0
2020-07-23 05:30:00	SPY	ETF	327.98	327.98	327.7	327.85	13369.0
2020-07-23 06:00:00	SPY	ETF	327.85	328.27	327.79	327.87	24651.0
2020-07-23 06:30:00	SPY	ETF	327.91	327.91	327.59	327.64	25621.0
2020-07-23 07:00:00	SPY	ETF	327.68	327.93	327.55	327.55	122474.0
2020-07-23 07:30:00	SPY	ETF	327.55	327.8	327.21	327.65	197795.0
2020-07-23 08:00:00	SPY	ETF	327.9	328.19	326.53	327.5399	113570.0
2020-07-23 08:30:00	SPY	ETF	327.39	327.6	326.29	326.3	361877.0
2020-07-23 09:00:00	SPY	ETF	326.28	326.81	326.23	326.44	204794.0
2020-07-23 09:30:00	SPY	ETF	326.47	327.23	326.121	326.99	4798200.0
2020-07-23 10:00:00	SPY	ETF	327.0	327.09	325.5238	326.4	4256786.0
2020-07-23 10:30:00	SPY	ETF	326.41	326.96	326.15	326.26	2766657.0
2020-07-23 11:00:00	SPY	ETF	326.26	326.75	325.83	326.68	2817131.0
2020-07-23 11:30:00	SPY	ETF	326.69	327.12	326.5	326.64	2168530.0
2020-07-23 12:00:00	SPY	ETF	326.665	326.67	325.43	325.75	2705890.0
2020-07-23 12:30:00	SPY	ETF	325.75	325.9193	324.98	325.27	4437826.0
2020-07-23 13:00:00	SPY	ETF	325.25	325.9	324.65	324.9501	3259572.0
2020-07-23 13:30:00	SPY	ETF	324.95	325.02	322.98	323.57	5652992.0
2020-07-23 14:00:00	SPY	ETF	323.56	323.59	321.48	322.61	8654552.0
2020-07-23 14:30:00	SPY	ETF	322.62	323.28	321.89	322.95	5036864.0
2020-07-23 15:00:00	SPY	ETF	322.96	323.24	321.91	322.467	5316055.0
2020-07-23 15:30:00	SPY	ETF	322.48	323.06	321.72	322.935	16464237.0
2020-07-23 16:00:00	SPY	ETF	322.94	323.05	322.05	322.68	4964793.0
2020-07-23 16:30:00	SPY	ETF	322.69	323.04	322.61	323.0	208240.0
2020-07-23 17:00:00	SPY	ETF	323.0	323.06	322.85	323.03	68105.0
2020-07-23 17:30:00	SPY	ETF	323.03	323.08	322.91	322.98	38145.0
2020-07-23 18:00:00	SPY	ETF	323.04	323.51	323.04	323.45	88526.0
2020-07-23 18:30:00	SPY	ETF	323.5	323.59	323.45	323.59	28056.0
2020-07-23 19:00:00	SPY	ETF	323.55	323.55	323.11	323.49	21019.0
2020-07-23 19:30:00	SPY	ETF	323.56	323.61	323.14	323.45	34025.0
2020-07-23 04:00:00	QQQ	ETF	266.29	266.43	266.05	266.33	19427.0
2020-07-23 04:30:00	QQQ	ETF	266.29	266.29	265.66	265.66	14300.0
2020-07-23 05:00:00	QQQ	ETF	265.68	266.09	265.64	266.09	10051.0
2020-07-23 05:30:00	QQQ	ETF	265.99	265.99	265.54	265.82	6865.0
2020-07-23 06:00:00	QQQ	ETF	265.99	266.13	265.74	265.85	18522.0
2020-07-23 06:30:00	QQQ	ETF	266.03	266.03	265.64	265.75	8893.0
2020-07-23 07:00:00	QQQ	ETF	265.79	265.93	265.26	265.33	137315.0
2020-07-23 07:30:00	QQQ	ETF	265.3	265.5	265.1	265.45	72756.0
2020-07-23 08:00:00	QQQ	ETF	265.91	266.0904	264.3	265.39	115821.0
2020-07-23 08:30:00	QQQ	ETF	265.28	265.42	264.55	264.64	125414.0
2020-07-23 09:00:00	QQQ	ETF	264.54	264.9799	264.41	264.52	157428.0
2020-07-23 09:30:00	QQQ	ETF	264.55	265.24	263.46	264.57	3294817.0
2020-07-23 10:00:00	QQQ	ETF	264.57	264.83	262.7722	263.845	2531478.0
2020-07-23 10:30:00	QQQ	ETF	263.85	264.61	263.66	263.76	1512712.0
2020-07-23 11:00:00	QQQ	ETF	263.77	264.2	263.14	263.82	1214331.0
2020-07-23 11:30:00	QQQ	ETF	263.83	264.09	263.22	263.31	1471761.0
2020-07-23 12:00:00	QQQ	ETF	263.31	263.32	261.19	261.45	2752064.0
2020-07-23 12:30:00	QQQ	ETF	261.44	261.64	259.88	260.81	3168771.0

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

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