PREVIEW / etf_30min / 2020-04-13

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-04-13.parquet
  size:    586 KB
  rows:    21,645

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-04-13 04:00:00	SPY	ETF	274.63	274.71	274.2	274.2	53749.0
2020-04-13 04:30:00	SPY	ETF	274.21	274.67	274.07	274.6	23684.0
2020-04-13 05:00:00	SPY	ETF	274.6	275.19	274.59	274.89	42712.0
2020-04-13 05:30:00	SPY	ETF	274.8	274.95	274.58	274.71	20281.0
2020-04-13 06:00:00	SPY	ETF	274.81	274.95	274.4	274.81	38029.0
2020-04-13 06:30:00	SPY	ETF	274.89	275.94	274.83	275.35	93503.0
2020-04-13 07:00:00	SPY	ETF	275.35	276.43	275.35	276.4	319393.0
2020-04-13 07:30:00	SPY	ETF	276.43	277.1	276.28	276.98	418672.0
2020-04-13 08:00:00	SPY	ETF	276.91	277.67	274.18	277.02	699181.0
2020-04-13 08:30:00	SPY	ETF	277.09	278.0	276.76	277.33	555743.0
2020-04-13 09:00:00	SPY	ETF	277.34	278.2	277.11	277.19	731876.0
2020-04-13 09:30:00	SPY	ETF	277.14	277.51	273.96	274.15	12945993.0
2020-04-13 10:00:00	SPY	ETF	274.15	275.59	272.75	273.48	9287652.0
2020-04-13 10:30:00	SPY	ETF	273.48	273.77	272.1	272.7298	9382182.0
2020-04-13 11:00:00	SPY	ETF	272.76	273.66	271.41	273.5	8818147.0
2020-04-13 11:30:00	SPY	ETF	273.52	274.1	272.62	273.6173	5919867.0
2020-04-13 12:00:00	SPY	ETF	273.6	275.07	273.38	274.165	6196360.0
2020-04-13 12:30:00	SPY	ETF	274.16	274.29	272.94	273.27	6392619.0
2020-04-13 13:00:00	SPY	ETF	273.286	273.47	272.45	272.9	5674319.0
2020-04-13 13:30:00	SPY	ETF	272.91	274.57	272.6702	274.085	6282896.0
2020-04-13 14:00:00	SPY	ETF	274.08	274.81	272.97	273.5969	5604338.0
2020-04-13 14:30:00	SPY	ETF	273.58	274.41	273.17	274.25	4907653.0
2020-04-13 15:00:00	SPY	ETF	274.23	275.18	273.22	274.85	8058060.0
2020-04-13 15:30:00	SPY	ETF	274.84	276.6	274.59	275.57	14529126.0
2020-04-13 16:00:00	SPY	ETF	275.58	276.33	274.0126	276.1999	4260324.0
2020-04-13 16:30:00	SPY	ETF	276.2	276.33	275.76	276.21	1652336.0
2020-04-13 17:00:00	SPY	ETF	276.25	276.26	275.66	276.19	362504.0
2020-04-13 17:30:00	SPY	ETF	276.14	276.5	275.66	276.4	121614.0
2020-04-13 18:00:00	SPY	ETF	276.36	276.97	275.66	276.72	211292.0
2020-04-13 18:30:00	SPY	ETF	276.74	277.32	276.61	276.98	125271.0
2020-04-13 19:00:00	SPY	ETF	276.99	277.13	276.9	276.96	36882.0
2020-04-13 19:30:00	SPY	ETF	276.94	277.08	276.7	277.08	108577.0
2020-04-13 04:00:00	QQQ	ETF	198.18	198.39	198.09	198.1	12901.0
2020-04-13 04:30:00	QQQ	ETF	198.18	198.5	198.08	198.5	22485.0
2020-04-13 05:00:00	QQQ	ETF	198.48	199.02	198.48	199.02	11440.0
2020-04-13 05:30:00	QQQ	ETF	198.76	198.8	198.59	198.66	11010.0
2020-04-13 06:00:00	QQQ	ETF	198.67	198.84	198.43	198.75	7921.0
2020-04-13 06:30:00	QQQ	ETF	198.73	199.44	198.73	199.14	15984.0
2020-04-13 07:00:00	QQQ	ETF	199.09	199.75	199.02	199.7	94985.0
2020-04-13 07:30:00	QQQ	ETF	199.77	200.34	199.75	200.21	88070.0
2020-04-13 08:00:00	QQQ	ETF	199.4601	200.57	197.73	200.11	213029.0
2020-04-13 08:30:00	QQQ	ETF	200.1	200.65	199.89	200.23	102918.0
2020-04-13 09:00:00	QQQ	ETF	200.27	200.5499	199.96	199.96	134959.0
2020-04-13 09:30:00	QQQ	ETF	199.92	201.25	199.28	199.48	4932361.0
2020-04-13 10:00:00	QQQ	ETF	199.48	200.89	199.12	199.715	3505888.0
2020-04-13 10:30:00	QQQ	ETF	199.715	200.11	199.25	199.67	2829888.0
2020-04-13 11:00:00	QQQ	ETF	199.68	200.37	198.75	200.285	2763498.0
2020-04-13 11:30:00	QQQ	ETF	200.265	200.7851	199.81	200.315	2135301.0
2020-04-13 12:00:00	QQQ	ETF	200.315	201.24	200.2	200.65	2379566.0
2020-04-13 12:30:00	QQQ	ETF	200.65	200.84	200.07	200.34	2001650.0

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

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