PREVIEW / etf_5min / 2011-01-19

all etf 5-min files

  file:    by_date/etf_5min/2011/2011-01-19.parquet
  size:    902 KB
  rows:    36,954

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
2011-01-19 04:00:00	SPY	ETF	129.65	129.67	129.65	129.67	200.0
2011-01-19 04:05:00	SPY	ETF	129.66	129.69	129.66	129.69	800.0
2011-01-19 04:10:00	SPY	ETF	129.69	129.69	129.65	129.65	1200.0
2011-01-19 04:15:00	SPY	ETF	129.64	129.64	129.64	129.64	700.0
2011-01-19 04:20:00	SPY	ETF	129.59	129.59	129.59	129.59	100.0
2011-01-19 04:45:00	SPY	ETF	129.74	129.74	129.74	129.74	1744.0
2011-01-19 04:55:00	SPY	ETF	129.68	129.68	129.68	129.68	100.0
2011-01-19 05:00:00	SPY	ETF	129.66	129.66	129.66	129.66	100.0
2011-01-19 05:15:00	SPY	ETF	129.62	129.62	129.62	129.62	100.0
2011-01-19 05:20:00	SPY	ETF	129.57	129.57	129.57	129.57	300.0
2011-01-19 05:35:00	SPY	ETF	129.75	129.75	129.75	129.75	500.0
2011-01-19 06:05:00	SPY	ETF	129.69	129.7	129.69	129.7	1300.0
2011-01-19 06:20:00	SPY	ETF	129.72	129.72	129.62	129.62	1200.0
2011-01-19 06:35:00	SPY	ETF	129.62	129.62	129.6	129.6	3000.0
2011-01-19 06:45:00	SPY	ETF	129.6	129.6	129.59	129.59	16000.0
2011-01-19 06:50:00	SPY	ETF	129.64	129.64	129.64	129.64	100.0
2011-01-19 06:55:00	SPY	ETF	129.7	129.7	129.7	129.7	600.0
2011-01-19 07:00:00	SPY	ETF	129.7	129.73	129.69	129.71	1600.0
2011-01-19 07:05:00	SPY	ETF	129.71	129.8	129.71	129.78	3225.0
2011-01-19 07:10:00	SPY	ETF	129.73	129.73	129.71	129.71	5610.0
2011-01-19 07:20:00	SPY	ETF	129.72	129.74	129.72	129.74	10110.0
2011-01-19 07:25:00	SPY	ETF	129.74	129.74	129.73	129.73	1500.0
2011-01-19 07:30:00	SPY	ETF	129.78	129.79	129.76	129.76	21199.0
2011-01-19 07:35:00	SPY	ETF	129.8	129.8	129.77	129.8	3600.0
2011-01-19 07:40:00	SPY	ETF	129.77	129.8	129.77	129.79	3000.0
2011-01-19 07:45:00	SPY	ETF	129.81	129.81	129.76	129.79	15600.0
2011-01-19 07:50:00	SPY	ETF	129.83	129.9	129.83	129.9	6200.0
2011-01-19 07:55:00	SPY	ETF	129.89	129.92	129.88	129.9	159225.0
2011-01-19 08:00:00	SPY	ETF	129.89	129.89	129.55	129.55	1115027.0
2011-01-19 08:05:00	SPY	ETF	129.54	129.67	129.5	129.59	370203.0
2011-01-19 08:10:00	SPY	ETF	129.59	129.61	129.55	129.55	134203.0
2011-01-19 08:15:00	SPY	ETF	129.54	129.55	129.44	129.46	153332.0
2011-01-19 08:20:00	SPY	ETF	129.49	129.55	129.44	129.54	114423.0
2011-01-19 08:25:00	SPY	ETF	129.54	129.56	129.52	129.54	35134.0
2011-01-19 08:30:00	SPY	ETF	129.52	129.59	129.35	129.58	182474.0
2011-01-19 08:35:00	SPY	ETF	129.59	129.61	129.56	129.59	47340.0
2011-01-19 08:40:00	SPY	ETF	129.59	129.6	129.53	129.58	66572.0
2011-01-19 08:45:00	SPY	ETF	129.58	129.58	129.56	129.57	30372.0
2011-01-19 08:50:00	SPY	ETF	129.57	129.62	129.56	129.59	44204.0
2011-01-19 08:55:00	SPY	ETF	129.58	129.58	129.39	129.42	355565.0
2011-01-19 09:00:00	SPY	ETF	129.42	129.43	129.3	129.33	322646.0
2011-01-19 09:05:00	SPY	ETF	129.34	129.36	129.32	129.33	66358.0
2011-01-19 09:10:00	SPY	ETF	129.33	129.39	129.33	129.34	61746.0
2011-01-19 09:15:00	SPY	ETF	129.35	129.42	129.33	129.42	106768.0
2011-01-19 09:20:00	SPY	ETF	129.42	129.44	129.4	129.43	169728.0
2011-01-19 09:25:00	SPY	ETF	129.43	129.43	129.38	129.41	96868.0
2011-01-19 09:30:00	SPY	ETF	129.41	129.5	129.36	129.42	3966390.0
2011-01-19 09:35:00	SPY	ETF	129.42	129.43	129.29	129.31	3204944.0
2011-01-19 09:40:00	SPY	ETF	129.3	129.31	129.18	129.21	2554761.0
2011-01-19 09:45:00	SPY	ETF	129.2001	129.26	129.14	129.175	2725851.0

> showing 50 of 36,954 rows — these rows as CSV

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