PREVIEW / etf_30min / 2009-10-09

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-10-09.parquet
  size:    224 KB
  rows:    7,464

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
2009-10-09 04:00:00	SPY	ETF	106.9	106.9	106.79	106.79	200.0
2009-10-09 04:30:00	SPY	ETF	106.66	106.71	106.66	106.66	2748.0
2009-10-09 05:00:00	SPY	ETF	106.66	106.66	106.66	106.66	5000.0
2009-10-09 05:30:00	SPY	ETF	106.51	106.51	106.45	106.48	2100.0
2009-10-09 06:00:00	SPY	ETF	106.48	106.7	106.48	106.65	5700.0
2009-10-09 06:30:00	SPY	ETF	106.58	106.69	106.58	106.65	1301.0
2009-10-09 07:00:00	SPY	ETF	106.72	106.86	106.7	106.73	59272.0
2009-10-09 07:30:00	SPY	ETF	106.73	106.73	106.66	106.66	75971.0
2009-10-09 08:00:00	SPY	ETF	106.65	106.69	106.33	106.4	1319581.0
2009-10-09 08:30:00	SPY	ETF	106.41	106.72	106.37	106.64	1433990.0
2009-10-09 09:00:00	SPY	ETF	106.63	106.7	106.47	106.64	1745144.0
2009-10-09 09:30:00	SPY	ETF	106.64	106.91	106.36	106.8901	17223796.0
2009-10-09 10:00:00	SPY	ETF	106.89	106.99	106.68	106.85	14440041.0
2009-10-09 10:30:00	SPY	ETF	106.85	107.01	106.75	106.89	10115210.0
2009-10-09 11:00:00	SPY	ETF	106.89	107.03	106.8	106.9499	9987350.0
2009-10-09 11:30:00	SPY	ETF	106.945	107.02	106.78	106.81	8474036.0
2009-10-09 12:00:00	SPY	ETF	106.81	106.9	106.63	106.68	7084859.0
2009-10-09 12:30:00	SPY	ETF	106.679	106.85	106.64	106.84	3727273.0
2009-10-09 13:00:00	SPY	ETF	106.8484	106.97	106.7317	106.91	5596892.0
2009-10-09 13:30:00	SPY	ETF	106.91	106.935	106.83	106.881	3864841.0
2009-10-09 14:00:00	SPY	ETF	106.89	106.9	106.76	106.821	7026728.0
2009-10-09 14:30:00	SPY	ETF	106.83	107.02	106.82	107.02	5777738.0
2009-10-09 15:00:00	SPY	ETF	107.02	107.24	107.0	107.11	9767302.0
2009-10-09 15:30:00	SPY	ETF	107.11	107.26	106.98	107.24	14817935.0
2009-10-09 16:00:00	SPY	ETF	107.24	107.32	106.54	107.29	7710404.0
2009-10-09 16:30:00	SPY	ETF	107.3	107.39	106.6361	107.29	4230797.0
2009-10-09 17:00:00	SPY	ETF	107.3	107.36	107.26	107.34	34552.0
2009-10-09 17:30:00	SPY	ETF	107.36	107.36	107.31	107.32	14675.0
2009-10-09 18:00:00	SPY	ETF	107.35	107.38	107.32	107.33	9150.0
2009-10-09 18:30:00	SPY	ETF	107.33	107.39	107.32	107.38	4600.0
2009-10-09 19:00:00	SPY	ETF	107.39	107.39	107.38	107.39	8775.0
2009-10-09 19:30:00	SPY	ETF	107.39	107.4	107.38	107.39	14258.0
2009-10-09 05:30:00	QQQ	ETF	42.11	42.11	42.06	42.06	400.0
2009-10-09 06:00:00	QQQ	ETF	42.11	42.11	42.11	42.11	100.0
2009-10-09 06:30:00	QQQ	ETF	42.14	42.14	42.14	42.14	2000.0
2009-10-09 07:00:00	QQQ	ETF	42.15	42.19	42.15	42.17	13074.0
2009-10-09 07:30:00	QQQ	ETF	42.17	42.17	42.13	42.13	94378.0
2009-10-09 08:00:00	QQQ	ETF	42.14	42.14	42.03	42.07	312204.0
2009-10-09 08:30:00	QQQ	ETF	42.07	42.16	42.04	42.12	300742.0
2009-10-09 09:00:00	QQQ	ETF	42.13	42.17	42.08	42.16	1061820.0
2009-10-09 09:30:00	QQQ	ETF	42.15	42.44	42.06	42.4112	13483037.0
2009-10-09 10:00:00	QQQ	ETF	42.42	42.48	42.32	42.41	4649809.0
2009-10-09 10:30:00	QQQ	ETF	42.4001	42.47	42.35	42.4079	4332900.0
2009-10-09 11:00:00	QQQ	ETF	42.4	42.48	42.36	42.45	2399408.0
2009-10-09 11:30:00	QQQ	ETF	42.45	42.48	42.39	42.39	2293195.0
2009-10-09 12:00:00	QQQ	ETF	42.39	42.43	42.3494	42.37	3256802.0
2009-10-09 12:30:00	QQQ	ETF	42.3601	42.4	42.33	42.3999	1855705.0
2009-10-09 13:00:00	QQQ	ETF	42.4	42.48	42.37	42.45	3024169.0
2009-10-09 13:30:00	QQQ	ETF	42.45	42.47	42.36	42.39	1159251.0
2009-10-09 14:00:00	QQQ	ETF	42.39	42.42	42.35	42.385	1808012.0

> showing 50 of 7,464 rows — these rows as CSV

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