PREVIEW / etf_30min / 2009-06-03

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-03.parquet
  size:    223 KB
  rows:    7,410

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-06-03 04:00:00	SPY	ETF	94.32	94.39	94.27	94.39	505.0
2009-06-03 04:30:00	SPY	ETF	94.25	94.26	94.19	94.19	3200.0
2009-06-03 05:00:00	SPY	ETF	94.2	94.31	94.11	94.14	2800.0
2009-06-03 05:30:00	SPY	ETF	94.19	94.19	94.14	94.14	200.0
2009-06-03 06:00:00	SPY	ETF	94.22	94.26	94.14	94.26	2600.0
2009-06-03 06:30:00	SPY	ETF	94.29	94.31	94.18	94.23	21600.0
2009-06-03 07:00:00	SPY	ETF	94.23	94.26	94.13	94.15	118873.0
2009-06-03 07:30:00	SPY	ETF	94.18	94.34	94.1	94.3	487542.0
2009-06-03 08:00:00	SPY	ETF	94.3	94.6	94.1	94.33	1655049.0
2009-06-03 08:30:00	SPY	ETF	94.32	94.88	93.91	93.99	1377324.0
2009-06-03 09:00:00	SPY	ETF	93.99	95.05	93.85	94.04	1863956.0
2009-06-03 09:30:00	SPY	ETF	94.04	94.13	93.5	93.69	28385111.0
2009-06-03 10:00:00	SPY	ETF	93.68	93.69	93.28	93.51	23726770.0
2009-06-03 10:30:00	SPY	ETF	93.52	93.71	93.37	93.7	10530517.0
2009-06-03 11:00:00	SPY	ETF	93.7	93.79	93.42	93.66	9631819.0
2009-06-03 11:30:00	SPY	ETF	93.64	93.75	93.43	93.48	10069539.0
2009-06-03 12:00:00	SPY	ETF	93.48	93.55	93.28	93.3	10538051.0
2009-06-03 12:30:00	SPY	ETF	93.3	93.42	93.12	93.162	10163091.0
2009-06-03 13:00:00	SPY	ETF	93.16	93.17	92.93	93.01	9766272.0
2009-06-03 13:30:00	SPY	ETF	93.0	93.1	92.79	92.95	15446869.0
2009-06-03 14:00:00	SPY	ETF	92.95	93.05	92.82	92.94	11542732.0
2009-06-03 14:30:00	SPY	ETF	92.9401	93.22	92.82	93.12	17296748.0
2009-06-03 15:00:00	SPY	ETF	93.11	93.22	92.85	92.86	15931078.0
2009-06-03 15:30:00	SPY	ETF	92.86	93.66	92.76	93.65	39740824.0
2009-06-03 16:00:00	SPY	ETF	93.65	93.68	92.9141	93.62	10659905.0
2009-06-03 16:30:00	SPY	ETF	93.62	93.7	93.57	93.59	4287792.0
2009-06-03 17:00:00	SPY	ETF	93.59	94.8598	93.46	93.52	1241475.0
2009-06-03 17:30:00	SPY	ETF	93.49	93.54	93.47	93.5	17213.0
2009-06-03 18:00:00	SPY	ETF	93.51	93.64	93.48	93.48	55252.0
2009-06-03 18:30:00	SPY	ETF	93.49	93.52	93.46	93.52	19125.0
2009-06-03 19:00:00	SPY	ETF	93.51	93.51	93.45	93.46	16184.0
2009-06-03 19:30:00	SPY	ETF	93.46	93.49	93.45	93.46	24130.0
2009-06-03 04:00:00	QQQ	ETF	36.33	36.33	36.33	36.33	1500.0
2009-06-03 05:00:00	QQQ	ETF	36.32	36.32	36.32	36.32	100.0
2009-06-03 07:00:00	QQQ	ETF	36.25	36.28	36.23	36.25	26490.0
2009-06-03 07:30:00	QQQ	ETF	36.22	36.32	36.21	36.3	107600.0
2009-06-03 08:00:00	QQQ	ETF	36.31	36.36	36.23	36.31	504193.0
2009-06-03 08:30:00	QQQ	ETF	36.31	36.31	36.16	36.2	247951.0
2009-06-03 09:00:00	QQQ	ETF	36.21	36.3	36.14	36.28	615464.0
2009-06-03 09:30:00	QQQ	ETF	36.28	36.33	36.1	36.16	13445931.0
2009-06-03 10:00:00	QQQ	ETF	36.16	36.17	36.04	36.15	9941295.0
2009-06-03 10:30:00	QQQ	ETF	36.15	36.29	36.11	36.29	5807400.0
2009-06-03 11:00:00	QQQ	ETF	36.29	36.34	36.16	36.3	4286189.0
2009-06-03 11:30:00	QQQ	ETF	36.3	36.37	36.24	36.26	4539642.0
2009-06-03 12:00:00	QQQ	ETF	36.26	36.29	36.15	36.16	3837365.0
2009-06-03 12:30:00	QQQ	ETF	36.16	36.2	36.06	36.0712	6422337.0
2009-06-03 13:00:00	QQQ	ETF	36.07	36.11	36.03	36.0517	3827133.0
2009-06-03 13:30:00	QQQ	ETF	36.05	36.1	35.93	36.03	8411296.0
2009-06-03 14:00:00	QQQ	ETF	36.04	36.15	35.97	36.04	4064016.0
2009-06-03 14:30:00	QQQ	ETF	36.04	36.17	35.99	36.1199	5121616.0

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

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