PREVIEW / etf_30min / 2009-09-03

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-09-03.parquet
  size:    222 KB
  rows:    7,350

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-09-03 04:00:00	SPY	ETF	100.3	100.3	100.3	100.3	3000.0
2009-09-03 04:30:00	SPY	ETF	100.38	100.45	100.38	100.45	850.0
2009-09-03 05:00:00	SPY	ETF	100.4	100.4	100.4	100.4	200.0
2009-09-03 05:30:00	SPY	ETF	100.31	100.31	100.31	100.31	5000.0
2009-09-03 06:00:00	SPY	ETF	100.35	100.38	100.35	100.38	1700.0
2009-09-03 06:30:00	SPY	ETF	100.34	100.41	100.29	100.41	1400.0
2009-09-03 07:00:00	SPY	ETF	100.44	100.68	100.4	100.65	135884.0
2009-09-03 07:30:00	SPY	ETF	100.64	100.87	100.64	100.66	694943.0
2009-09-03 08:00:00	SPY	ETF	100.65	100.82	100.35	100.77	990356.0
2009-09-03 08:30:00	SPY	ETF	100.77	100.8	100.36	100.46	4372891.0
2009-09-03 09:00:00	SPY	ETF	100.45	100.53	100.31	100.4	1007154.0
2009-09-03 09:30:00	SPY	ETF	100.4	100.62	100.09	100.35	19292517.0
2009-09-03 10:00:00	SPY	ETF	100.35	100.77	99.59	99.87	27549702.0
2009-09-03 10:30:00	SPY	ETF	99.86	100.1	99.8	100.01	9816325.0
2009-09-03 11:00:00	SPY	ETF	100.01	100.33	100.0	100.07	10069663.0
2009-09-03 11:30:00	SPY	ETF	100.06	100.22	100.04	100.17	4674126.0
2009-09-03 12:00:00	SPY	ETF	100.17	100.29	100.12	100.21	10270551.0
2009-09-03 12:30:00	SPY	ETF	100.2	100.25	100.09	100.15	2561691.0
2009-09-03 13:00:00	SPY	ETF	100.1507	100.38	100.15	100.275	3937848.0
2009-09-03 13:30:00	SPY	ETF	100.28	100.35	100.15	100.19	3903680.0
2009-09-03 14:00:00	SPY	ETF	100.1999	100.27	100.04	100.11	3143489.0
2009-09-03 14:30:00	SPY	ETF	100.115	100.13	99.92	100.08	3871250.0
2009-09-03 15:00:00	SPY	ETF	100.07	100.25	100.06	100.2	4667852.0
2009-09-03 15:30:00	SPY	ETF	100.2	100.77	100.19	100.66	22301688.0
2009-09-03 16:00:00	SPY	ETF	100.66	100.75	99.8906	100.63	6515118.0
2009-09-03 16:30:00	SPY	ETF	100.65	100.79	100.64	100.68	3168941.0
2009-09-03 17:00:00	SPY	ETF	100.68	100.71	100.2021	100.64	50263.0
2009-09-03 17:30:00	SPY	ETF	100.66	100.71	100.62	100.67	67850.0
2009-09-03 18:00:00	SPY	ETF	100.69	100.72	100.65	100.7	164940.0
2009-09-03 18:30:00	SPY	ETF	100.7	100.71	100.66	100.66	11400.0
2009-09-03 19:00:00	SPY	ETF	100.66	100.71	100.66	100.68	11906.0
2009-09-03 19:30:00	SPY	ETF	100.72	100.77	100.7	100.76	30092.0
2009-09-03 04:00:00	QQQ	ETF	39.38	39.38	39.38	39.38	100.0
2009-09-03 05:30:00	QQQ	ETF	39.41	39.41	39.39	39.39	7500.0
2009-09-03 06:00:00	QQQ	ETF	39.42	39.42	39.42	39.42	2000.0
2009-09-03 07:00:00	QQQ	ETF	39.41	39.51	39.41	39.49	9074.0
2009-09-03 07:30:00	QQQ	ETF	39.51	39.61	39.48	39.52	170960.0
2009-09-03 08:00:00	QQQ	ETF	39.52	39.56	39.39	39.53	249681.0
2009-09-03 08:30:00	QQQ	ETF	39.51	39.51	39.4	39.47	419252.0
2009-09-03 09:00:00	QQQ	ETF	39.45	39.48	39.4	39.44	426834.0
2009-09-03 09:30:00	QQQ	ETF	39.44	39.5	39.16	39.28	13534491.0
2009-09-03 10:00:00	QQQ	ETF	39.27	39.38	39.02	39.15	12530897.0
2009-09-03 10:30:00	QQQ	ETF	39.14	39.29	39.0949	39.2501	8471751.0
2009-09-03 11:00:00	QQQ	ETF	39.26	39.37	39.25	39.28	5687615.0
2009-09-03 11:30:00	QQQ	ETF	39.282	39.38	39.27	39.3601	2744792.0
2009-09-03 12:00:00	QQQ	ETF	39.3501	39.428	39.34	39.4	2219248.0
2009-09-03 12:30:00	QQQ	ETF	39.4	39.4	39.3301	39.36	1519055.0
2009-09-03 13:00:00	QQQ	ETF	39.37	39.47	39.36	39.46	2079632.0
2009-09-03 13:30:00	QQQ	ETF	39.4501	39.49	39.35	39.4107	2035655.0
2009-09-03 14:00:00	QQQ	ETF	39.412	39.43	39.32	39.34	1499024.0

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

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