PREVIEW / etf_30min / 2020-01-07

all etf 30-min files

  file:    by_date/etf_30min/2020/2020-01-07.parquet
  size:    549 KB
  rows:    19,390

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-01-07 04:00:00	SPY	ETF	324.1	324.13	323.9	323.95	9245.0
2020-01-07 04:30:00	SPY	ETF	324.06	324.06	323.6	323.81	3424.0
2020-01-07 05:00:00	SPY	ETF	323.9	323.91	323.58	323.69	5434.0
2020-01-07 05:30:00	SPY	ETF	323.61	323.81	323.61	323.78	6769.0
2020-01-07 06:00:00	SPY	ETF	323.76	323.93	323.58	323.58	6789.0
2020-01-07 06:30:00	SPY	ETF	323.53	323.61	323.38	323.41	19736.0
2020-01-07 07:00:00	SPY	ETF	323.49	323.7	323.45	323.66	68288.0
2020-01-07 07:30:00	SPY	ETF	323.69	323.8	323.57	323.78	34909.0
2020-01-07 08:00:00	SPY	ETF	323.56	324.2	323.37	323.56	175482.0
2020-01-07 08:30:00	SPY	ETF	323.49	324.2	322.94	322.99	360250.0
2020-01-07 09:00:00	SPY	ETF	322.97	323.16	322.85	323.0	301888.0
2020-01-07 09:30:00	SPY	ETF	323.02	323.29	322.24	322.56	6016034.0
2020-01-07 10:00:00	SPY	ETF	322.58	322.99	322.55	322.96	3007470.0
2020-01-07 10:30:00	SPY	ETF	322.945	323.37	322.45	323.2547	2772596.0
2020-01-07 11:00:00	SPY	ETF	323.26	323.54	323.22	323.45	1629405.0
2020-01-07 11:30:00	SPY	ETF	323.46	323.4729	322.73	322.845	2511808.0
2020-01-07 12:00:00	SPY	ETF	322.845	323.0556	322.71	322.985	1106389.0
2020-01-07 12:30:00	SPY	ETF	322.98	322.98	322.73	322.9	1670963.0
2020-01-07 13:00:00	SPY	ETF	322.9	323.15	322.895	323.04	2114820.0
2020-01-07 13:30:00	SPY	ETF	323.04	323.15	322.88	323.149	971884.0
2020-01-07 14:00:00	SPY	ETF	323.15	323.17	322.64	322.85	1674066.0
2020-01-07 14:30:00	SPY	ETF	322.86	323.02	322.7	322.99	1375585.0
2020-01-07 15:00:00	SPY	ETF	322.99	323.36	322.975	323.29	2696473.0
2020-01-07 15:30:00	SPY	ETF	323.29	323.3	322.5	322.76	6362491.0
2020-01-07 16:00:00	SPY	ETF	322.76	322.807	322.46	322.5	3935512.0
2020-01-07 16:30:00	SPY	ETF	322.53	322.54	321.64	322.32	734453.0
2020-01-07 17:00:00	SPY	ETF	322.33	322.33	322.21	322.25	22596.0
2020-01-07 17:30:00	SPY	ETF	322.22	322.28	322.15	322.24	136144.0
2020-01-07 18:00:00	SPY	ETF	322.15	322.4	319.6	320.42	448077.0
2020-01-07 18:30:00	SPY	ETF	320.41	320.49	318.74	319.47	743187.0
2020-01-07 19:00:00	SPY	ETF	319.48	319.54	317.91	317.92	519612.0
2020-01-07 19:30:00	SPY	ETF	317.98	318.38	317.25	318.27	679026.0
2020-01-07 04:00:00	QQQ	ETF	215.9	216.01	215.81	216.01	12885.0
2020-01-07 04:30:00	QQQ	ETF	216.04	216.04	215.7	215.83	10200.0
2020-01-07 05:00:00	QQQ	ETF	215.92	215.94	215.67	215.75	8450.0
2020-01-07 05:30:00	QQQ	ETF	215.76	215.86	215.7	215.82	11704.0
2020-01-07 06:00:00	QQQ	ETF	215.87	215.98	215.7	215.7	18100.0
2020-01-07 06:30:00	QQQ	ETF	215.68	215.77	215.55	215.63	15167.0
2020-01-07 07:00:00	QQQ	ETF	215.61	215.87	215.61	215.87	35655.0
2020-01-07 07:30:00	QQQ	ETF	215.83	215.99	215.76	215.92	52621.0
2020-01-07 08:00:00	QQQ	ETF	215.75	216.25	215.51	215.79	92936.0
2020-01-07 08:30:00	QQQ	ETF	215.7	215.7	215.3	215.38	111767.0
2020-01-07 09:00:00	QQQ	ETF	215.32	215.68	215.32	215.64	111488.0
2020-01-07 09:30:00	QQQ	ETF	215.63	215.89	214.85	215.38	2688518.0
2020-01-07 10:00:00	QQQ	ETF	215.37	215.8299	215.35	215.6124	2109831.0
2020-01-07 10:30:00	QQQ	ETF	215.61	215.9	215.05	215.84	1516311.0
2020-01-07 11:00:00	QQQ	ETF	215.84	216.14	215.82	216.0267	1369106.0
2020-01-07 11:30:00	QQQ	ETF	216.05	216.06	215.5766	215.68	753201.0
2020-01-07 12:00:00	QQQ	ETF	215.68	215.9066	215.57	215.8826	500741.0
2020-01-07 12:30:00	QQQ	ETF	215.87	215.87	215.66	215.83	459604.0

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

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