PREVIEW / etf_30min / 2009-06-23

all etf 30-min files

  file:    by_date/etf_30min/2009/2009-06-23.parquet
  size:    221 KB
  rows:    7,313

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-23 04:30:00	SPY	ETF	89.38	89.74	89.38	89.74	1550.0
2009-06-23 05:00:00	SPY	ETF	89.74	89.76	89.72	89.74	725.0
2009-06-23 05:30:00	SPY	ETF	89.62	89.62	89.62	89.62	1000.0
2009-06-23 06:00:00	SPY	ETF	89.7	89.75	89.7	89.7	6400.0
2009-06-23 06:30:00	SPY	ETF	89.7	89.8	89.63	89.7	72229.0
2009-06-23 07:00:00	SPY	ETF	89.66	89.71	89.52	89.61	176343.0
2009-06-23 07:30:00	SPY	ETF	89.53	89.71	89.53	89.56	117986.0
2009-06-23 08:00:00	SPY	ETF	89.56	89.85	89.0	89.79	1114914.0
2009-06-23 08:30:00	SPY	ETF	89.8	89.81	89.53	89.66	1276590.0
2009-06-23 09:00:00	SPY	ETF	89.66	89.71	89.41	89.5	680456.0
2009-06-23 09:30:00	SPY	ETF	89.47	89.81	89.35	89.75	23922061.0
2009-06-23 10:00:00	SPY	ETF	89.76	89.88	89.12	89.12	23289929.0
2009-06-23 10:30:00	SPY	ETF	89.12	89.35	88.95	89.1806	17886961.0
2009-06-23 11:00:00	SPY	ETF	89.18	89.24	88.85	89.18	12968365.0
2009-06-23 11:30:00	SPY	ETF	89.18	89.46	89.15	89.42	9079831.0
2009-06-23 12:00:00	SPY	ETF	89.42	89.45	89.2	89.26	9948831.0
2009-06-23 12:30:00	SPY	ETF	89.26	89.6	89.26	89.41	10830787.0
2009-06-23 13:00:00	SPY	ETF	89.41	89.75	89.1	89.46	15523328.0
2009-06-23 13:30:00	SPY	ETF	89.47	89.56	89.25	89.27	5589768.0
2009-06-23 14:00:00	SPY	ETF	89.27	89.72	89.21	89.55	8981605.0
2009-06-23 14:30:00	SPY	ETF	89.55	89.62	89.295	89.47	9472682.0
2009-06-23 15:00:00	SPY	ETF	89.47	89.66	89.24	89.62	10286920.0
2009-06-23 15:30:00	SPY	ETF	89.62	89.77	89.36	89.43	19446021.0
2009-06-23 16:00:00	SPY	ETF	89.43	89.75	89.0	89.48	4606716.0
2009-06-23 16:30:00	SPY	ETF	89.47	89.498	89.2927	89.42	1565911.0
2009-06-23 17:00:00	SPY	ETF	89.4	89.46	89.36	89.42	205535.0
2009-06-23 17:30:00	SPY	ETF	89.45	89.5106	89.45	89.5	129600.0
2009-06-23 18:00:00	SPY	ETF	89.47	89.47	89.36	89.39	52201.0
2009-06-23 18:30:00	SPY	ETF	89.41	89.43	89.39	89.43	9200.0
2009-06-23 19:00:00	SPY	ETF	89.43	89.43	89.32	89.35	52688.0
2009-06-23 19:30:00	SPY	ETF	89.35	89.44	89.33	89.44	55614.0
2009-06-23 04:30:00	QQQ	ETF	35.17	35.26	35.17	35.26	5497.0
2009-06-23 05:00:00	QQQ	ETF	35.29	35.3	35.29	35.3	200.0
2009-06-23 05:30:00	QQQ	ETF	35.25	35.25	35.25	35.25	100.0
2009-06-23 06:00:00	QQQ	ETF	35.26	35.26	35.26	35.26	100.0
2009-06-23 06:30:00	QQQ	ETF	35.27	35.28	35.25	35.25	500.0
2009-06-23 07:00:00	QQQ	ETF	35.26	35.27	35.21	35.23	25100.0
2009-06-23 07:30:00	QQQ	ETF	35.23	35.29	35.23	35.24	223125.0
2009-06-23 08:00:00	QQQ	ETF	35.26	35.31	35.24	35.28	277186.0
2009-06-23 08:30:00	QQQ	ETF	35.27	35.27	35.23	35.26	160661.0
2009-06-23 09:00:00	QQQ	ETF	35.27	35.27	35.16	35.2	377262.0
2009-06-23 09:30:00	QQQ	ETF	35.2	35.26	34.92	35.05	19911492.0
2009-06-23 10:00:00	QQQ	ETF	35.05	35.12	34.81	34.85	15587303.0
2009-06-23 10:30:00	QQQ	ETF	34.85	34.97	34.79	34.89	8989608.0
2009-06-23 11:00:00	QQQ	ETF	34.88	34.92	34.77	34.9	5318444.0
2009-06-23 11:30:00	QQQ	ETF	34.9	35.02	34.89	35.01	5755331.0
2009-06-23 12:00:00	QQQ	ETF	35.02	35.02	34.86	34.91	4584305.0
2009-06-23 12:30:00	QQQ	ETF	34.92	35.04	34.92	34.94	6031768.0
2009-06-23 13:00:00	QQQ	ETF	34.95	35.09	34.94	34.99	8398298.0
2009-06-23 13:30:00	QQQ	ETF	35.0	35.05	34.91	34.92	1899374.0

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

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